Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Database Design And Implementation

Authors: Shouhong Wang, Hai Wang

1st Edition

1612330150, 978-1612330150

More Books

Students also viewed these Databases questions

Question

Are my points each supported by at least two subpoints?

Answered: 1 week ago