Question: 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
Get step-by-step solutions from verified subject matter experts
