1. Trovare nome (customerName) di tutti i clienti. +------------------------------------+ | customerName | +------------------------------------+ | Atelier graphique | | Signal Gift Stores | | Australian Collectors, Co. | | La Rochelle Gifts | | Baane Mini Imports | | Mini Gifts Distributors Ltd. | | Havel & Zbyszek Co | | Blauer See Auto, Co. | | Mini Wheels Co. | | Land of Toys Inc. | | Euro+ Shopping Channel | | Volvo Model Replicas, Co | | Danish Wholesale Imports | | Saveley & Henriot, Co. | | Dragon Souveniers, Ltd. | | Muscle Machine Inc | | Diecast Classics Inc. | | Technics Stores Inc. | | Handji Gifts& Co | | Herkku Gifts | | American Souvenirs Inc | | Porto Imports Co. | | Daedalus Designs Imports | | La Corne D'abondance, Co. | | Cambridge Collectables Co. | | Gift Depot Inc. | | Osaka Souveniers Co. | | Vitachrome Inc. | | Toys of Finland, Co. | | AV Stores, Co. | | Clover Collections, Co. | | Auto-Moto Classics Inc. | | UK Collectables, Ltd. | | Canadian Gift Exchange Network | | Online Mini Collectables | | Toys4GrownUps.com | | Asian Shopping Network, Co | | Mini Caravy | | King Kong Collectables, Co. | | Enaco Distributors | | Boards & Toys Co. | | Natürlich Autos | | Heintze Collectables | | Québec Home Shopping Network | | ANG Resellers | | Collectable Mini Designs Co. | | giftsbymail.co.uk | | Alpha Cognac | | Messner Shopping Network | | Amica Models & Co. | | Lyon Souveniers | | Auto Associés & Cie. | | Toms Spezialitäten, Ltd | | Royal Canadian Collectables, Ltd. | | Franken Gifts, Co | | Anna's Decorations, Ltd | | Rovelli Gifts | | Souveniers And Things Co. | | Marta's Replicas Co. | | BG&E Collectables | | Vida Sport, Ltd | | Norway Gifts By Mail, Co. | | Schuyler Imports | | Der Hund Imports | | Oulu Toy Supplies, Inc. | | Petit Auto | | Mini Classics | | Mini Creations Ltd. | | Corporate Gift Ideas Co. | | Down Under Souveniers, Inc | | Stylish Desk Decors, Co. | | Tekni Collectables Inc. | | Australian Gift Network, Co | | Suominen Souveniers | | Cramer Spezialitäten, Ltd | | Classic Gift Ideas, Inc | | CAF Imports | | Men 'R' US Retailers, Ltd. | | Asian Treasures, Inc. | | Marseille Mini Autos | | Reims Collectables | | SAR Distributors, Co | | GiftsForHim.com | | Kommission Auto | | Gifts4AllAges.com | | Online Diecast Creations Co. | | Lisboa Souveniers, Inc | | Precious Collectables | | Collectables For Less Inc. | | Royale Belge | | Salzburg Collectables | | Cruz & Sons Co. | | L'ordine Souveniers | | Tokyo Collectables, Ltd | | Auto Canal+ Petit | | Stuttgart Collectable Exchange | | Extreme Desk Decorations, Ltd | | Bavarian Collectables Imports, Co. | | Classic Legends Inc. | | Feuer Online Stores, Inc | | Gift Ideas Corp. | | Scandinavian Gift Ideas | | The Sharp Gifts Warehouse | | Mini Auto Werke | | Super Scale Inc. | | Microscale Inc. | | Corrida Auto Replicas, Ltd | | Warburg Exchange | | FunGiftIdeas.com | | Anton Designs, Ltd. | | Australian Collectables, Ltd | | Frau da Collezione | | West Coast Collectables Co. | | Mit Vergnügen & Co. | | Kremlin Collectables, Co. | | Raanan Stores, Inc | | Iberia Gift Imports, Corp. | | Motor Mint Distributors Inc. | | Signal Collectibles Ltd. | | Double Decker Gift Stores, Ltd | | Diecast Collectables | | Kelly's Gift Shop | +------------------------------------+ 122 rows in set (0.00 sec) 2. Trovare la citta´(city) dove ha sede il cliente Frau da Collezione. +-------+ | city | +-------+ | Milan | +-------+ 1 row in set (0.00 sec) 3. Trovare il Nome (firstname), Cognome (lastname), e la email del presidente (cioe' con jobTitle="president"). +-----------+----------+------------------------------+ | firstName | lastName | email | +-----------+----------+------------------------------+ | Diane | Murphy | dmurphy@classicmodelcars.com | +-----------+----------+------------------------------+ 1 row in set (0.00 sec) 4. Trovare il Nome e il limite di credito (creditLimit) di tutti i clienti che hanno un limite di credito > di 100000. +------------------------------+-------------+ | customerName | creditLimit | +------------------------------+-------------+ | Australian Collectors, Co. | 117300 | | La Rochelle Gifts | 118200 | | Mini Gifts Distributors Ltd. | 210500 | | Land of Toys Inc. | 114900 | | Euro+ Shopping Channel | 227600 | | Saveley & Henriot, Co. | 123900 | | Dragon Souveniers, Ltd. | 103800 | | Muscle Machine Inc | 138500 | | Diecast Classics Inc. | 100600 | | AV Stores, Co. | 136800 | | Heintze Collectables | 120800 | | Collectable Mini Designs Co. | 105000 | | Amica Models & Co. | 113000 | | Toms Spezialitäten, Ltd | 120400 | | Anna's Decorations, Ltd | 107800 | | Rovelli Gifts | 119600 | | Marta's Replicas Co. | 123700 | | Vida Sport, Ltd | 141300 | | Mini Classics | 102700 | | Corporate Gift Ideas Co. | 105000 | | Online Diecast Creations Co. | 114200 | | L'ordine Souveniers | 121400 | | Scandinavian Gift Ideas | 116400 | | Corrida Auto Replicas, Ltd | 104600 | | Kelly's Gift Shop | 110000 | +------------------------------+-------------+ 25 rows in set (0.01 sec) 5. Trovare tutte le linee di prodotti (ogni linea deve comparire una sola volta) +------------------+ | productline | +------------------+ | Classic Cars | | Motorcycles | | Planes | | Ships | | Trains | | Trucks and Buses | | Vintage Cars | +------------------+ 7 rows in set (0.00 sec) 6. Restituire il Nome (firstName) e Cognome (lastName) dei dipendenti in ordine alfabetico (prima sul cognome e poi sul nome). +-----------+-----------+ | lastName | firstName | +-----------+-----------+ | Bondur | Gerard | | Bondur | Loui | | Bott | Larry | | Bow | Anthony | | Castillo | Pamela | | Firrelli | Jeff | | Firrelli | Julie | | Fixter | Andy | | Gerard | Martin | | Hernandez | Gerard | | Jennings | Leslie | | Jones | Barry | | Kato | Yoshimi | | King | Tom | | Marsh | Peter | | Murphy | Diane | | Nishi | Mami | | Patterson | Mary | | Patterson | Steve | | Patterson | William | | Thompson | Leslie | | Tseng | Foon Yue | | Vanauf | George | +-----------+-----------+ 23 rows in set (0.00 sec) 7. Trovare per ogni dipendente il suo Cognome e quello delle persone che dirige. +------------+-----------+ | Dipendente | Dirige | +------------+-----------+ | Murphy | Patterson | | Murphy | Firrelli | | Patterson | Patterson | | Patterson | Bondur | | Patterson | Bow | | Bow | Jennings | | Bow | Thompson | | Bow | Firrelli | | Bow | Patterson | | Bow | Tseng | | Bow | Vanauf | | Bondur | Bondur | | Bondur | Hernandez | | Bondur | Castillo | | Bondur | Bott | | Bondur | Jones | | Patterson | Fixter | | Patterson | Marsh | | Patterson | King | | Patterson | Nishi | | Nishi | Kato | | Bondur | Gerard | +------------+-----------+ 22 rows in set (0.00 sec) 8. Trovare il prezzo minimo, massimo e medio di ciscuna linea di prodotti +------------------+--------+------------------+---------+ | productLine | Minimo | Medio | Massimo | +------------------+--------+------------------+---------+ | Classic Cars | 15.91 | 64.4463157894737 | 103.42 | | Motorcycles | 24.14 | 50.6853846153846 | 91.02 | | Planes | 29.34 | 49.6291666666667 | 77.27 | | Ships | 33.3 | 47.0077777777778 | 82.34 | | Trains | 26.72 | 43.9233333333333 | 67.56 | | Trucks and Buses | 24.92 | 56.3290909090909 | 84.76 | | Vintage Cars | 20.61 | 46.06625 | 86.7 | +------------------+--------+------------------+---------+ 7 rows in set (0.00 sec) 9. Restituire il nome (customerName) e il limite di credito (creditLimit) dei primi dieci clienti in ordine di limite di credito decrescente (usare LIMIT) +------------------------------+---------+ | Nome | credito | +------------------------------+---------+ | Euro+ Shopping Channel | 227600 | | Mini Gifts Distributors Ltd. | 210500 | | Vida Sport, Ltd | 141300 | | Muscle Machine Inc | 138500 | | AV Stores, Co. | 136800 | | Saveley & Henriot, Co. | 123900 | | Marta's Replicas Co. | 123700 | | L'ordine Souveniers | 121400 | | Heintze Collectables | 120800 | | Toms Spezialitäten, Ltd | 120400 | +------------------------------+---------+ 10 rows in set (0.00 sec) 10. Capire se esiste un dipendente con il ruolo di dirigente (Sale Manager (EMEA)) a Tokyo +----------+ | lastName | +----------+ | Bondur | +----------+ 1 row in set (0.00 sec) 11. Il nome delle citta' con sedi con almeno 3 dipendenti. +---------------+ | city | +---------------+ | Paris | | San Francisco | | Sydney | +---------------+ 3 rows in set (0.01 sec) 12. Trovare il nome di tutti i clienti della sede di Tokyo +-----------------------------+ | customerName | +-----------------------------+ | Dragon Souveniers, Ltd. | | Osaka Souveniers Co. | | King Kong Collectables, Co. | | Cruz & Sons Co. | | Tokyo Collectables, Ltd | +-----------------------------+ 5 rows in set (0.00 sec) 13. Trovare il nome dei clienti che hanno ordinato prodotti della linea planes +------------------------------------+ | customerName | +------------------------------------+ | Rovelli Gifts | | Salzburg Collectables | | Australian Collectors, Co. | | Gift Ideas Corp. | | Down Under Souveniers, Inc | | Euro+ Shopping Channel | | Mini Creations Ltd. | | Toys4GrownUps.com | | Toys of Finland, Co. | | Frau da Collezione | | Scandinavian Gift Ideas | | Technics Stores Inc. | | Alpha Cognac | | Kelly's Gift Shop | | Double Decker Gift Stores, Ltd | | King Kong Collectables, Co. | | Herkku Gifts | | Enaco Distributors | | Cruz & Sons Co. | | West Coast Collectables Co. | | Men 'R' US Retailers, Ltd. | | Osaka Souveniers Co. | | Collectable Mini Designs Co. | | Extreme Desk Decorations, Ltd | | Royal Canadian Collectables, Ltd. | | Cambridge Collectables Co. | | The Sharp Gifts Warehouse | | Gift Depot Inc. | | Collectables For Less Inc. | | La Rochelle Gifts | | Norway Gifts By Mail, Co. | | Marta's Replicas Co. | | Bavarian Collectables Imports, Co. | | Clover Collections, Co. | | Classic Gift Ideas, Inc | | Mini Classics | | giftsbymail.co.uk | | Diecast Classics Inc. | | Danish Wholesale Imports | | Land of Toys Inc. | | Royale Belge | | Tokyo Collectables, Ltd | | Stylish Desk Decors, Co. | | Auto-Moto Classics Inc. | | Souveniers And Things Co. | | Oulu Toy Supplies, Inc. | | Australian Gift Network, Co | | FunGiftIdeas.com | | Reims Collectables | | Tekni Collectables Inc. | | Australian Collectables, Ltd | | L'ordine Souveniers | +------------------------------------+ 52 rows in set (0.00 sec) 14 Elencare il numero identificativo dei dipendenti e il numero di clienti gestito da ciascuno +--------+---------+ | number | norders | +--------+---------+ | 1165 | 6 | | 1166 | 6 | | 1188 | 6 | | 1216 | 6 | | 1286 | 7 | | 1323 | 8 | | 1337 | 6 | | 1370 | 7 | | 1401 | 10 | | 1501 | 8 | | 1504 | 9 | | 1611 | 5 | | 1612 | 5 | | 1621 | 5 | | 1702 | 6 | +--------+---------+ 15 rows in set (0.00 sec)