SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete -- Table “klanten” CREATE TABLE klanten ( klantId int(11) NOT NULL, klantNaam varchar(255) DEFAULT NULL, PRIMARY KEY (klantId) ) ENGINE=InnoDB; INSERT INTO klanten VALUES(2809,'Land of Toys Inc.'), (2794,'Reims Collectables'), (2452,'Lyon Souveniers'), (2644,'Toys4GrownUps.com'), (2531,'Corporate Gift Ideas Co.'), (2748,'Technics Stores Inc.'), (2441,'Daedalus Designs Imports'), (2646,'Herkku Gifts'), (2296,'Mini Wheels Co.'), (2443,'Auto Canal Petit'), (2673,'Australian Collectors Co.'), (2633,'Vitachrome Inc.'), (2768,'Tekni Collectables Inc.'), (2651,'Gift Depot Inc.'), (2815,'La Rochelle Gifts'), (2653,'Martas Replicas Co.'), (2774,'Toys of Finland Co.'), (2614,'Baane Mini Imports'), (2656,'Diecast Classics Inc.'), (2771,'Salzburg Collectables'), (2791,'Souveniers And Things Co.'), (2662,'FunGiftIdeas.com'), (2456,'UK Collectables Ltd.'), (2820,'Euro Shopping Channel'), (2476,'Volvo Model Replicas Co'), (2635,'Corrida Auto Replicas Ltd'), (2798,'Dragon Souveniers Ltd.'), (2817,'Classic Legends Inc.'), (2254,'Australian Gift Network Co'), (2786,'Classic Gift Ideas Inc'), (2806,'Saveley & Henriot Co.'), (2632,'Canadian Gift Exchange Network'), (2671,'West Coast Collectables Co.'), (2781,'Cambridge Collectables Co.'), (2626,'Super Scale Inc.'), (2789,'Tokyo Collectables Ltd'), (2813,'Amica Models & Co.'), (2802,'Scandinavian Gift Ideas'), (2631,'Auto Assoc. & Cie.'), (2800,'Mini Gifts Distributors Ltd.'), (2024,'Online Diecast Creations Co.'), (2783,'Collectables For Less Inc.'), (2437,'Annas Decorations Ltd'), (2810,'Quebec Home Shopping Network'), (2751,'Osaka Souveniers Co.'), (2450,'Motor Mint Distributors Inc.'), (1635,'Atelier graphique'), (2759,'Mini Classics'), (2816,'Danish Wholesale Imports'), (2799,'Stylish Desk Decors Co.'), (2804,'Mini Creations Ltd.'), (2821,'Alpha Cognac'), (2777,'Double Decker Gift Stores Ltd'), (2805,'Enaco Distributors'), (2779,'Men R US Retailers Ltd.'), (2807,'Collectable Mini Designs Co.'), (2811,'Petit Auto'), (2812,'Royal Canadian Collectables Ltd.'), (2822,'Gifts4AllAges.com'), (2808,'giftsbymail.co.uk'), (2819,'Oulu Toy Supplies Inc.'), (2795,'The Sharp Gifts Warehouse'), (2634,'La Corne Dabondance Co.'), (2619,'Mini Auto Werke'), (2387,'Diecast Collectables'), (2624,'Handji Gifts& Co'), (2750,'Cruz & Sons Co.'), (2218,'Marseille Mini Autos'), (2213,'Toms Spezialitten Ltd'), (2136,'Vida Sport Ltd'), (2769,'Lordine Souveniers'), (2733,'Online Mini Collectables'), (2417,'Blauer See Auto Co.'), (2418,'Suominen Souveniers'), (2408,'Muscle Machine Inc'), (2654,'Clover Collections Co.'), (2803,'CAF Imports'), (2814,'AV Stores Co.'), (2526,'Heintze Collectables'), (2449,'Microscale Inc.'), (2592,'Boards & Toys Co.'), (2385,'Iberia Gift Imports Corp.'), (2232,'Signal Collectibles Ltd.'), (1995,'Mini Caravy'), (2041,'Signal Gift Stores'), (2757,'Norway Gifts By Mail Co.'), (2770,'Rovelli Gifts'), (2796,'Australian Collectables Ltd'), (2772,'Gift Ideas Corp.'), (2785,'Bavarian Collectables Imports Co.'), (2306,'Royale Belge'), (2790,'Auto-Moto Classics Inc.'), (3000,'IBM'), (3001,'NAND'); -- Table “producten” CREATE TABLE producten ( productId int(11) NOT NULL, productNaam varchar(255) DEFAULT NULL, prijsPerEenheid DOUBLE(10, 2), PRIMARY KEY (productId) ) ENGINE=InnoDB; INSERT INTO producten VALUES(101678,'S10_1678',100), (101949,'S10_1949',100), (102016,'S10_2016',100), (104698,'S10_4698',100), (104757,'S10_4757',100), (104962,'S10_4962',100), (121099,'S12_1099',100), (121108,'S12_1108',100), (121666,'S12_1666',100), (122823,'S12_2823',100), (123148,'S12_3148',100), (123380,'S12_3380',100), (123891,'S12_3891',100), (123990,'S12_3990',90.17), (124473,'S12_4473',100), (124675,'S12_4675',100), (181097,'S18_1097',100), (181129,'S18_1129',100), (181342,'S18_1342',95.55), (181367,'S18_1367',51.75), (181589,'S18_1589',100), (181662,'S18_1662',100), (181749,'S18_1749',100), (181889,'S18_1889',83.93), (181984,'S18_1984',100), (182238,'S18_2238',100), (182248,'S18_2248',63.57), (182319,'S18_2319',99.41), (182325,'S18_2325',100), (182432,'S18_2432',49.22), (182581,'S18_2581',98.84), (182625,'S18_2625',61.18), (182795,'S18_2795',100), (182870,'S18_2870',100), (182949,'S18_2949',88.14), (182957,'S18_2957',53.72), (183029,'S18_3029',73.98), (183136,'S18_3136',84.82), (183140,'S18_3140',100), (183232,'S18_3232',100), (183259,'S18_3259',100), (183278,'S18_3278',100), (183320,'S18_3320',89.29), (183482,'S18_3482',100), (183685,'S18_3685',100), (183782,'S18_3782',52.22), (183856,'S18_3856',100), (184027,'S18_4027',100), (184409,'S18_4409',92.95), (184522,'S18_4522',75.48), (184600,'S18_4600',100), (184668,'S18_4668',59.87), (184721,'S18_4721',100), (184933,'S18_4933',57.73), (241046,'S24_1046',64.67), (241444,'S24_1444',46.82), (241578,'S24_1578',100), (241628,'S24_1628',60.37), (241785,'S24_1785',88.63), (241937,'S24_1937',26.88), (242000,'S24_2000',87.6), (242011,'S24_2011',100), (242022,'S24_2022',45.7), (242300,'S24_2300',100), (242360,'S24_2360',79.65), (242766,'S24_2766',100), (242840,'S24_2840',33.24), (242841,'S24_2841',67.82), (242887,'S24_2887',96.3), (242972,'S24_2972',42.67), (243151,'S24_3151',100), (243191,'S24_3191',96.74), (243371,'S24_3371',52.66), (243420,'S24_3420',69.7), (243432,'S24_3432',100), (243816,'S24_3816',76.31), (243856,'S24_3856',100), (243949,'S24_3949',75.06), (243969,'S24_3969',43.49), (244048,'S24_4048',100), (244258,'S24_4258',78.89), (244278,'S24_4278',74.62), (244620,'S24_4620',82.42), (321268,'S32_1268',86.68), (321374,'S32_1374',100), (322206,'S32_2206',40.23), (322509,'S32_2509',43.83), (323207,'S32_3207',49.71), (323522,'S32_3522',61.41), (324289,'S32_4289',61.22), (324485,'S32_4485',100), (501341,'S50_1341',51.93), (1,'NS_046',12), (2,'NS_979',0.45), (3,'AD_324',7.5), (4,'SF_978',6), (5,'NS_378',16), (6,'NS_977',75); -- Table “verkopen” CREATE TABLE verkopen ( verkoopId int(11) NOT NULL, productId int(11) NOT NULL, klantId int(11) DEFAULT NULL, datum date, aantal int(11) DEFAULT NULL, contactPersoon varchar(255) DEFAULT NULL, PRIMARY KEY (verkoopId, productId) ) ENGINE=InnoDB; INSERT INTO verkopen VALUES(10107,321374,2809,'2013-2-24',20,'Kwai Yu'), (10121,504713,2794,'2013-5-7',44,'Paul Henriot'), (10134,242000,2452,'2013-7-1',43,'Daniel Da Cunha'), (10145,7002834,2644,'2013-8-25',20,'Julie Young'), (10159,504713,2531,'2013-10-10',31,'Julie Brown'), (10168,7004002,2748,'2013-10-28',39,'Juri Hirano'), (10180,504713,2441,'2013-11-11',21,'Martine Rance'), (10188,7002834,2646,'2013-11-18',29,'Veysel Oeztan'), (10201,242000,2296,'2013-12-1',25,'Julie Murphy'), (10211,504713,2443,'2014-1-15',40,'Dominique Perrier'), (10223,7003167,2673,'2014-2-20',26,'Peter Ferguson'), (10237,504713,2633,'2014-4-5',20,'Michael Frick'), (10251,241578,2768,'2014-5-18',26,'William Brown'), (10263,7002834,2651,'2014-6-28',47,'Julie King'), (10275,7004002,2815,'2014-7-23',31,'Janine Labrune'), (10285,7002834,2653,'2014-8-27',45,'Marta Hernandez'), (10299,504713,2774,'2014-9-30',44,'Matti Karttunen'), (10309,504713,2614,'2014-10-15',28,'Jonas Bergulfsen'), (10318,7002834,2656,'2014-11-2',50,'Kyung Yu'), (10329,721253,2809,'2014-11-15',44,'Kwai Yu'), (10341,7003167,2771,'2014-11-24',34,'Georg Pipps'), (10361,721253,2791,'2014-12-17',23,'Adrian Huxley'), (10375,7003167,2815,'2015-2-3',44,'Janine Labrune'), (10388,7002834,2662,'2015-3-3',50,'Violeta Benitez'), (10403,504713,2456,'2015-4-8',31,'Elizabeth Devon'), (10417,241578,2820,'2015-5-13',35,'Diego Freyre'), (10103,7002824,2614,'2013-1-29',42,'Jonas Bergulfsen'), (10112,182949,2476,'2013-3-24',23,'Christina Berglund'), (10126,7002824,2635,'2013-5-28',45,'Mart¡n Sommer'), (10140,7002824,2748,'2013-7-24',36,'Juri Hirano'), (10150,7002824,2798,'2013-9-19',20,'Eric Natividad'), (10163,244258,2817,'2013-10-20',42,'Maria Hernandez'), (10174,184668,2254,'2013-11-6',49,'Tony Calaghan'), (10183,7002824,2786,'2013-11-13',23,'Francisca Cervantes'), (10194,7002824,2806,'2013-11-25',26,'Mary Saveley'), (10206,7002824,2632,'2013-12-5',33,'Yoshi Tannamuri'), (10215,244258,2671,'2014-1-29',39,'Steve Thompson'), (10228,244258,2781,'2014-3-10',33,'Kyung Tseng'), (10245,7002824,2626,'2014-5-4',44,'Leslie Murphy'), (10258,7002824,2789,'2014-6-15',45,'Akiko Shimamura'), (10270,7002824,2791,'2014-7-19',46,'Adrian Huxley'), (10280,244258,2813,'2014-8-17',21,'Paolo Accorti'), (10291,7002824,2802,'2014-9-8',28,'Maria Larsson'), (10304,7002824,2631,'2014-10-11',40,'Daniel Tonini'), (10312,244258,2800,'2014-10-21',44,'Valarie Nelson'), (10322,242022,2024,'2014-11-4',30,'Valarie Young'), (10333,323522,2296,'2014-11-18',33,'Julie Murphy'), (10347,184600,2673,'2014-11-29',45,'Peter Ferguson'), (10357,184600,2800,'2014-12-10',28,'Valarie Nelson'), (10369,244258,2783,'2015-1-20',40,'Allen Nelson'), (10381,183136,2531,'2015-2-17',35,'Julie Brown'), (10391,242022,2437,'2015-3-9',24,'Anna OHara'), (10411,7002824,2810,'2015-5-1',34,'Jean Fresnisre'), (10424,7002824,2820,'2015-5-31',46,'Diego Freyre'), (10120,7003167,2673,'2013-4-29',43,'Peter Ferguson'), (10210,7004002,2751,'2014-1-12',42,'Mory Kentary'), (10236,242000,2450,'2014-4-3',36,'Rosa Hernandez'), (10298,182625,1635,'2014-9-27',32,'Carine Schmitt'), (10308,7004002,2759,'2014-10-15',39,'Steve Frick'), (10339,721253,2789,'2014-11-23',27,'Akiko Shimamura'), (10374,241785,2254,'2015-2-2',46,'Tony Calaghan'), (10402,242000,2443,'2015-4-7',59,'Dominique Perrier'), (10362,241578,2748,'2015-1-5',50,'Juri Hirano'), (10105,723212,2816,'2013-2-11',25,'Jytte Petersen'), (10119,721253,2771,'2013-4-28',28,'Georg Pipps'), (10129,723212,2799,'2013-6-12',32,'Ann Brown'), (10143,721253,2804,'2013-8-10',37,'Wing C Tam'), (10155,721253,2774,'2013-10-6',34,'Matti Karttunen'), (10167,723212,2802,'2013-10-23',38,'Maria Larsson'), (10178,721253,2821,'2013-11-8',45,'Annette Roulet'), (10186,721253,2777,'2013-11-14',28,'Thomas Hardy'), (10197,723212,2805,'2013-11-26',42,'Eduardo Saavedra'), (10209,721253,2779,'2014-1-9',48,'Michael Chandler'), (10222,723212,2807,'2014-2-19',36,'Valarie Thompson'), (10248,723212,2809,'2014-5-7',23,'Kwai Yu'), (10261,723212,2810,'2014-6-17',29,'Jean Fresnisre'), (10273,723212,2811,'2014-7-21',37,'Catherine Dewey'), (10283,723212,2812,'2014-8-20',33,'Elizabeth Lincoln'), (10295,7003505,2822,'2014-9-10',34,'Juri Yoshido'), (10307,721253,2786,'2014-10-14',34,'Francisca Cervantes'), (10316,721253,2808,'2014-11-1',34,'Helen Bennett'), (10325,501514,2614,'2014-11-5',44,'Jonas Bergulfsen'), (10337,723212,2817,'2014-11-21',42,'Maria Hernandez'), (10350,723212,2820,'2014-12-2',20,'Diego Freyre'), (10359,501514,2794,'2014-12-15',25,'Paul Henriot'), (10373,723212,2819,'2015-1-31',29,'Pirkko Koskitalo'), (10384,7001938,2531,'2015-2-23',49,'Julie Brown'), (10395,501514,2452,'2015-3-17',45,'Daniel Da Cunha'), (10400,721253,2795,'2015-4-1',20,'Sue Frick'), (10414,723212,2822,'2015-5-6',47,'Juri Yoshido'), (10114,7002824,2634,'2013-4-1',42,'Marie Bertrand'), (10164,7002824,2619,'2013-10-21',39,'Roland Mendel'), (10175,7002824,2799,'2013-11-6',42,'Ann Brown'), (10207,501392,2387,'2013-12-9',28,'Valarie Franco'), (10217,7002824,2624,'2014-2-4',31,'Wendy Victorino'), (10229,7002824,2800,'2014-3-11',50,'Valarie Nelson'), (10259,501392,2624,'2014-6-15',29,'Wendy Victorino'), (10281,7002824,2656,'2014-8-19',27,'Kyung Yu'), (10305,501392,2653,'2014-10-13',42,'Marta Hernandez'), (10313,7002824,2632,'2014-10-22',30,'Yoshi Tannamuri'), (10334,242300,2476,'2014-11-19',42,'Christina Berglund'), (10370,323522,2437,'2015-1-20',25,'Anna OHara'), (10425,501392,2815,'2015-5-31',18,'Janine Labrune'), (10108,504713,2750,'2013-3-3',34,'Arnold Cruz'), (10122,322206,2218,'2013-5-8',31,'Laurence Lebihan'), (10135,504713,2800,'2013-7-2',44,'Valarie Nelson'), (10147,244620,2783,'2013-9-5',31,'Allen Nelson'), (10169,504713,2437,'2013-11-4',48,'Anna OHara'), (10181,243856,2646,'2013-11-12',25,'Veysel Oeztan'), (10191,244620,2213,'2013-11-20',44,'Henriette Pfalzheim'), (10203,243856,2820,'2013-12-2',47,'Diego Freyre'), (10225,244620,2136,'2014-2-22',46,'Michael Holz'), (10238,244620,2816,'2014-4-9',22,'Jytte Petersen'), (10253,243856,2456,'2014-6-1',39,'Elizabeth Devon'), (10266,243856,2769,'2014-7-6',24,'Maurizio Moroni'), (10276,504713,2733,'2014-8-2',21,'Miguel Barajas'), (10287,244620,2136,'2014-8-30',40,'Michael Holz'), (10300,243371,2417,'2013-10-4',31,'Roland Keitel'), (10310,322206,2213,'2014-10-16',36,'Henriette Pfalzheim'), (10320,243371,2476,'2014-11-3',26,'Christina Berglund'), (10363,321374,2418,'2015-1-6',50,'Kalle Suominen'), (10389,242000,2802,'2015-3-3',49,'Maria Larsson'), (10419,243856,2771,'2015-5-17',70,'Georg Pipps'), (10117,723212,2798,'2013-4-16',50,'Eric Natividad'), (10127,501514,2408,'2013-6-3',46,'Jeff Young'), (10142,723212,2800,'2013-8-8',39,'Valarie Nelson'), (10153,723212,2820,'2013-9-28',50,'Diego Freyre'), (10165,501514,2798,'2013-10-22',38,'Eric Natividad'), (10176,501514,2769,'2013-11-6',38,'Maurizio Moroni'), (10185,723212,2804,'2013-11-14',28,'Wing C Tam'), (10196,7001938,2626,'2013-11-26',50,'Leslie Murphy'), (10208,723212,2806,'2014-1-2',42,'Mary Saveley'), (10220,501514,2654,'2014-2-12',30,'Dean Cassidy'), (10231,123891,2803,'2014-3-19',49,'Jesus Fernandez'), (10247,501514,2418,'2014-5-5',49,'Kalle Suominen'), (10272,501514,2656,'2014-7-20',43,'Kyung Yu'), (10282,7001938,2800,'2014-8-20',43,'Valarie Nelson'), (10293,723212,2813,'2014-9-9',32,'Paolo Accorti'), (10306,723212,2814,'2014-10-14',35,'Victoria Ashworth'), (10314,7001938,2526,'2014-10-22',23,'Palle Ibsen'), (10336,7002824,2634,'2014-11-20',46,'Marie Bertrand'), (10348,7002824,2635,'2014-11-1',32,'Mart¡n Sommer'), (10371,7002824,2800,'2015-1-23',34,'Valarie Nelson'), (10382,7002824,2800,'2015-2-17',34,'Valarie Nelson'), (10413,501514,2651,'2015-5-5',51,'Julie King'), (10113,323522,2800,'2013-3-26',23,'Valarie Nelson'), (10216,121666,2631,'2014-2-2',43,'Daniel Tonini'), (10189,122823,2644,'2013-11-18',28,'Julie Young'), (10224,504713,2441,'2014-2-21',50,'Martine Rance'), (10319,504713,2449,'2014-11-3',45,'Kee Kuo'), (10104,501514,2820,'2013-1-31',32,'Diego Freyre'), (10230,501514,2417,'2014-3-15',43,'Roland Keitel'), (10324,7002824,2633,'2014-11-5',34,'Michael Frick'), (10358,7002824,2820,'2014-12-10',27,'Diego Freyre'), (10372,7001938,2789,'2015-1-26',44,'Akiko Shimamura'), (10160,243856,2779,'2013-10-11',35,'Michael Chandler'), (10170,243856,2619,'2013-11-4',34,'Roland Mendel'), (10212,243856,2820,'2014-1-16',49,'Diego Freyre'), (10376,123380,2592,'2015-2-8',35,'Leslie Young'), (10349,322509,2408,'2014-12-1',33,'Jeff Young'), (10396,7001138,2800,'2015-3-23',39,'Valarie Nelson'), (10377,183232,2774,'2015-2-9',39,'Matti Karttunen'), (10115,501392,2817,'2013-4-4',27,'Maria Hernandez'), (10141,501392,2418,'2013-8-1',44,'Kalle Suominen'), (10151,501392,2819,'2013-9-21',26,'Pirkko Koskitalo'), (10184,501392,2385,'2013-11-14',45,'Jose Pedro Roel'), (10195,501392,2759,'2013-11-25',49,'Steve Frick'), (10219,322509,2232,'2014-2-10',35,'Sue Taylor'), (10246,501392,2820,'2014-5-5',22,'Diego Freyre'), (10271,501392,2800,'2014-7-20',34,'Valarie Nelson'), (10292,501514,2809,'2014-9-8',35,'Kwai Yu'), (10412,501392,2820,'2015-5-3',26,'Diego Freyre'), (10192,243856,2024,'2013-11-20',45,'Valarie Young'), (10239,243856,2819,'2014-4-12',29,'Pirkko Koskitalo'), (10277,124675,2798,'2014-8-4',28,'Eric Natividad'), (10321,243856,2662,'2014-11-4',26,'Violeta Benitez'), (10405,243856,1995,'2015-4-14',76,'Frederique Citeaux'), (10109,242972,2450,'2013-3-10',29,'Rosa Hernandez'), (10136,183232,2821,'2013-7-4',41,'Annette Roulet'), (10148,243432,2437,'2013-9-11',27,'Anna OHara'), (10161,243432,2526,'2013-10-17',30,'Palle Ibsen'), (10171,242972,2810,'2013-11-5',36,'Jean Fresnisre'), (10204,243969,2408,'2013-12-2',39,'Jeff Young'), (10240,183685,2751,'2014-4-13',37,'Mory Kentary'), (10278,243856,2041,'2014-8-6',25,'Sue King'), (10301,243856,2757,'2013-10-5',50,'Jan Klaeboe'), (10331,504713,2450,'2014-11-17',20,'Rosa Hernandez'), (10342,243856,2673,'2014-11-24',42,'Peter Ferguson'), (10356,504713,2452,'2014-12-9',26,'Daniel Da Cunha'), (10365,504713,2804,'2015-1-7',44,'Wing C Tam'), (10390,504713,2800,'2015-3-4',22,'Valarie Nelson'), (10406,183685,2816,'2015-4-15',65,'Jytte Petersen'), (10102,181367,2633,'2013-1-10',41,'Michael Frick'), (10111,244258,2296,'2013-3-25',26,'Julie Murphy'), (10125,182795,2673,'2013-5-21',34,'Peter Ferguson'), (10139,244258,2791,'2013-7-16',29,'Adrian Huxley'), (10149,244258,2232,'2013-9-12',20,'Sue Taylor'), (10162,243969,2531,'2013-10-18',37,'Julie Brown'), (10173,244258,2770,'2013-11-5',22,'Giovanni Rovelli'), (10182,243969,2800,'2013-11-12',23,'Valarie Nelson'), (10193,244258,2796,'2013-11-21',20,'Sean Connery'), (10205,242022,2820,'2013-12-3',24,'Diego Freyre'), (10227,243969,2806,'2014-3-2',27,'Mary Saveley'), (10244,244258,2820,'2014-4-29',40,'Diego Freyre'), (10256,181367,2816,'2014-6-8',29,'Jytte Petersen'), (10289,242022,2646,'2014-9-3',45,'Veysel Oeztan'), (10332,243969,2814,'2014-11-17',41,'Victoria Ashworth'), (10346,243969,2041,'2014-11-29',22,'Sue King'), (10380,243969,2820,'2015-2-16',43,'Diego Freyre'), (10422,181367,2656,'2015-5-30',25,'Kyung Yu'), (10110,243969,2814,'2013-3-18',48,'Victoria Ashworth'), (10123,241628,1635,'2013-5-20',50,'Carine Schmitt'), (10137,241628,2794,'2013-7-10',26,'Paul Henriot'), (10172,243432,2651,'2013-11-5',22,'Julie King'), (10226,243432,2807,'2014-2-26',48,'Valarie Thompson'), (10241,243432,1995,'2014-4-13',27,'Frederique Citeaux'), (10288,243969,2624,'2014-9-1',33,'Wendy Victorino'), (10311,243432,2820,'2014-10-16',46,'Diego Freyre'), (10343,322206,2794,'2014-11-24',29,'Paul Henriot'), (10367,242972,2644,'2015-1-12',36,'Julie Young'), (10378,322206,2820,'2015-2-10',40,'Diego Freyre'), (10407,243432,2795,'2015-4-22',43,'Sue Frick'), (10106,721253,2770,'2013-2-17',48,'Giovanni Rovelli'), (10131,721253,2772,'2013-6-16',21,'Dan Lewis'), (10198,7004002,2750,'2013-11-27',40,'Arnold Cruz'), (10250,7004002,2795,'2014-5-11',38,'Sue Frick'), (10262,721253,2820,'2014-6-24',21,'Diego Freyre'), (10274,721253,2783,'2014-7-21',32,'Allen Nelson'), (10284,7004002,2757,'2014-8-21',32,'Jan Klaeboe'), (10296,721253,2785,'2014-9-15',21,'Michael Donnermeyer'), (10327,723212,2816,'2014-11-10',37,'Jytte Petersen'), (10338,183856,2306,'2014-11-22',45,'Pascale Cartrain'), (10351,243949,2799,'2014-12-3',34,'Ann Brown'), (10386,723212,2820,'2015-3-1',43,'Diego Freyre'), (10398,721253,2794,'2015-3-30',34,'Paul Henriot'), (10416,7004002,2769,'2015-5-10',43,'Maurizio Moroni'), (10100,243969,2024,'2013-1-6',49,'Valarie Young'), (10124,243969,2041,'2013-5-21',46,'Sue King'), (10214,243969,2635,'2014-1-26',44,'Mart¡n Sommer'), (10302,243191,2456,'2013-10-6',48,'Elizabeth Devon'), (10344,241937,2218,'2014-11-25',20,'Laurence Lebihan'), (10379,241628,2820,'2015-2-10',32,'Diego Freyre'), (10420,243969,2791,'2015-5-29',15,'Adrian Huxley'), (10366,183232,2306,'2015-1-10',34,'Pascale Cartrain'), (10303,243969,2385,'2014-10-6',24,'Jose Pedro Roel'), (10383,501514,2820,'2015-2-22',38,'Diego Freyre'), (10101,242022,2417,'2013-1-9',46,'Roland Keitel'), (10243,241937,2387,'2014-4-26',33,'Valarie Franco'), (10409,241937,2624,'2015-4-23',61,'Wendy Victorino'), (10133,7002834,2820,'2013-6-27',27,'Diego Freyre'), (10235,7004002,2812,'2014-4-2',34,'Elizabeth Lincoln'), (10297,7002834,2654,'2014-9-16',35,'Dean Cassidy'), (10353,7003167,2772,'2014-12-4',43,'Dan Lewis'), (10401,7004002,2768,'2015-4-3',28,'William Brown'), (10255,242022,1995,'2014-6-4',37,'Frederique Citeaux'), (10421,242022,2800,'2015-5-29',40,'Valarie Nelson'), (10257,244258,2795,'2014-6-14',46,'Sue Frick'), (10423,244258,2811,'2015-5-30',28,'Catherine Dewey'), (10269,244258,2771,'2014-7-16',48,'Georg Pipps'), (10392,183320,2619,'2015-3-10',36,'Roland Mendel'), (10130,183856,2790,'2013-6-16',33,'Leslie Taylor'), (10128,7001938,2820,'2013-6-6',32,'Diego Freyre'), (10166,7001938,2662,'2013-10-21',29,'Violeta Benitez'), (10177,723212,2803,'2013-11-7',40,'Jesus Fernandez'), (10221,7001938,2811,'2014-2-18',23,'Catherine Dewey'), (10232,723212,2808,'2014-3-20',24,'Helen Bennett'), (10394,323207,2820,'2015-3-15',30,'Diego Freyre'), (10326,7001138,2476,'2014-11-9',39,'Christina Berglund'), (10252,504713,2443,'2014-5-26',48,'Dominique Perrier'), (10265,183482,2796,'2014-7-2',49,'Sean Connery'), (10290,244258,2790,'2014-9-7',45,'Leslie Taylor'), (10323,184600,2417,'2014-11-5',47,'Roland Keitel'), (10330,242360,2750,'2014-11-16',42,'Arnold Cruz'), (10355,324485,2820,'2014-12-7',40,'Diego Freyre'), (10146,184721,2772,'2013-9-3',29,'Dan Lewis'), (10264,504713,2822,'2014-6-30',47,'Juri Yoshido'), (10286,183782,2634,'2014-8-28',38,'Marie Bertrand'), (10249,721253,2781,'2014-5-8',32,'Kyung Tseng'), (10328,7004002,2770,'2014-11-12',39,'Giovanni Rovelli'), (10415,721253,2796,'2015-5-9',42,'Sean Connery'), (10152,323207,2254,'2013-9-25',33,'Tony Calaghan'), (10213,242887,2777,'2014-1-22',27,'Thomas Hardy'), (10315,723212,2815,'2014-10-29',40,'Janine Labrune'), (10267,243432,2408,'2014-7-7',43,'Jeff Young'), (10279,243432,2820,'2014-8-9',48,'Diego Freyre'), (10158,242000,2614,'2013-10-10',22,'Jonas Bergulfsen'), (10340,7002834,2805,'2014-11-24',29,'Eduardo Saavedra'), (10345,242022,1635,'2014-11-25',43,'Carine Schmitt'), (10190,504713,2820,'2013-11-19',40,'Diego Freyre'), (10368,243969,2800,'2015-1-19',46,'Valarie Nelson'), (10335,322509,2800,'2014-11-19',40,'Valarie Nelson'), (10154,7002610,2592,'2013-10-2',36,'Leslie Young'), (10233,7002610,2768,'2014-3-29',29,'William Brown'), (10385,7001138,2800,'2015-2-28',25,'Valarie Nelson'), (10242,243969,2449,'2014-4-20',46,'Kee Kuo'), (10408,243969,2789,'2015-4-22',15,'Akiko Shimamura'), (10317,244278,2748,'2014-11-2',35,'Juri Hirano'), (10387,321374,2798,'2015-3-2',44,'Eric Natividad'), (10364,322206,2218,'2015-1-6',48,'Laurence Lebihan'), (10116,323207,2306,'2013-4-11',27,'Pascale Cartrain'), (10144,324289,2306,'2013-8-13',20,'Pascale Cartrain'), (10156,7001691,2820,'2013-10-8',48,'Diego Freyre'), (10199,7003167,2671,'2013-12-1',38,'Steve Thompson'), (10397,723212,2821,'2015-3-28',34,'Annette Roulet'), (10352,721253,2790,'2014-12-3',49,'Leslie Taylor'), (10118,7003505,2805,'2013-4-21',36,'Eduardo Saavedra'), (10294,7003962,2733,'2014-9-10',45,'Miguel Barajas'), (1,1,3000,'2014-03-17',4972,'Stuart Dwight'), (1,2,3000,'2014-03-17',4972,'Stuart Dwight'), (1,3,3000,'2014-03-17',4972,'Stuart Dwight'), (1,4,3000,'2014-03-17',4972,'Stuart Dwight'), (1,5,3000,'2014-03-17',4972,'Stuart Dwight'), (1,6,3000,'2014-03-17',4972,'Stuart Dwight'), (2,1,2790,'2014-03-17',319,'Daniel Sanchez'), (2,2,2790,'2014-03-17',319,'Daniel Sanchez'), (2,3,2790,'2014-03-17',319,'Daniel Sanchez'), (2,4,2790,'2014-03-17',319,'Daniel Sanchez'), (2,5,2790,'2014-03-17',319,'Daniel Sanchez'), (2,6,2790,'2014-03-17',319,'Daniel Sanchez'), (3,1,2733,'2014-03-17',319,'Miguel Barajas'), (3,2,2733,'2014-03-17',319,'Miguel Barajas'), (3,3,2733,'2014-03-17',319,'Miguel Barajas'), (3,4,2733,'2014-03-17',319,'Miguel Barajas'), (3,5,2733,'2014-03-17',319,'Miguel Barajas'), (3,6,2733,'2014-03-17',319,'Miguel Barajas'), (4,1,2790,'2014-03-19',3148,'Leslie Taylor'), (4,2,2790,'2014-03-19',3148,'Leslie Taylor'), (4,3,2790,'2014-03-19',3148,'Leslie Taylor'), (4,4,2790,'2014-03-19',3148,'Leslie Taylor'), (4,5,2790,'2014-03-19',3148,'Leslie Taylor'), (4,6,2790,'2014-03-19',3148,'Leslie Taylor'), (5,241628,3001,'2014-03-25',25,'Tim Peeters'), (5,243969,3001,'2014-03-25',95,'Tim Peeters'), (5,183856,3001,'2014-03-25',55,'Tim Peeters'), (5,7001938,3001,'2014-03-25',23,'Tim Peeters'), (5,244278,3001,'2014-03-25',62,'Tim Peeters'), (5,7002834,3001,'2014-03-25',95,'Tim Peeters'); SELECT COUNT(*) FROM verkopen , klanten WHERE verkopen.klantId = klanten.klantId AND klantNaam = 'IBM' AND datum BETWEEN '2013−1−15' AND '2017−3−25' ;