Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In SQL, List customer name, contact last name, contact first name, phone, city, and credit limit for customers in the cities of Paris or Lyon
In SQL, List customer name, contact last name, contact first name, phone, city, and credit limit for customers in the cities of Paris or Lyon in France and who have a credit limit between 100000 and 130000
Query 1 Classic Models Create Classic Models New Load employees customers orders payments Limit to 5000 rows 1SELECT FROM classicmodels.customers 2SELECT customerName, contactLastname, contactFirstName, phone, city, creditLimit from customers Result Grid | Fiter Rows: Export: Wrap Cell Content: contactLastname contactFirstName phone creditLimit customerName Australian Collectors, Co. Ferguson La Rochelle Gifts Land of Toys Inc. Saveley &Henriot, Co. Dragon Souveniers, Ltd.Nati Diecast Classics Inc. Heintze Collectables Collectable Mini Designs Co. Thompson Amica Models & Co. Toms Spezialit iten, Ltd Pfalzheim Anna's Decorations, Ltd Result Grid Peter 03 9520 4555 Melbourne 117300 40.67.8555 2125557818 NYC 78.32.5555 Lyon +65 221 7555 Singapore 103800 2155551555 Allentown 100600 86 213555 rhus 1 7605558146 San Diego 105000 011-4988555 Torino 0221-5554327 KAln 02 9936 8555 North Sy... 107800 035-640555 6175558555 Cambridge 123700 9145554562 White Plains 102700 6505551386 San Fran. 6035558647 Nashua Nantes 118200 114900 Saveley Natividad Leong Palle Valarie Paolo 120800 113000 Types O'Hara Giovanni Bergamo 119600 Query Marta's Replicas Co. Mini Classics Corporate Gift Ideas Co. Online Diecast Creations Co. Hernandez Steve .. 105000 Young Dorothy 114200 customers 67 customers 68 ORead OnlyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started