Answered step by step
Verified Expert Solution
Question
1 Approved Answer
To prepare for the graded coding quiz, you will be asked to execute a query, read the results, and select the correct answer you found
To prepare for the graded coding quiz, you will be asked to execute a query, read the results, and select the correct answer you found in the results. This question is for you to practice executing queries. I have provided you the script for this query, a simple select statement. Think of this as a sandbox for you to practice. As you practice executing queries, take time to read the results in order to prepare for the quiz and get comfortable writing a basic select statement. Run Query: Return the Customer Id, Invoice Date, and Billing City from the Invoices table. What city is associated with Customer ID number 42? What was the invoice date for the customer in Santiago? 1 2 3 Select Customerid, InvoiceDate, BillingCity From Invoices; 4 | Customerid | InvoiceDate | BillingCity 2 | 2009-01-01 00:00:00 Stuttgart 4 | 2009-01-02 00:00:00 | Oslo 8 | 2009-01-03 00:00:00 | Brussels 14 | 2009-01-06 00:00:00 | Edmonton 23 | 2009-01-11 00:00:00 | Boston 37 | 2009-01-19 00:00:00 | Frankfurt 38 2009-02-01 00:00:00 | Berlin 40 | 2009-02-01 00:00:00 | Paris 42 | 2009-02-02 00:00:00 | Bordeaux 46 | 2009-02-03 00:00:00 | Dublin 52 | 2009-02-06 00:00:00 | London 2 | 2009-02-11 00:00:00 Stuttgart 16 2009-02-19 00:00:00 | Mountain View | 17 | 2009-03-04 00:00:00 | Redmond | 19 | 2009-03-04 00:00:00 | Cupertino 21 | 2009-03-05 00:00:00 | Reno 25 | 2009-03-06 00:00:00 | Madison 31 | 2009-03-09 00:00:00 | Halifax 40 | 2009-03-14 00:00:00 | Paris 54 | 2009-03-22 00:00:00 | Edinburgh 55 | 2009-04-04 00:00:00 | Sidney 57 | 2009-04-04 00:00:00 | Santiago 59 | 2009-04-05 00:00:00 | Bangalore 4 | 2009-04-06 00:00:00 | Oslo 10 | 2009-04-09 00:00:00 | So Paulo (Output limit exceeded, 25 of 412 total rows shown)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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