Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 Only

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions