sql
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: Retrieve all data from the invoices table. What is the billing address for customer 31? N P 1 2 Select From Invoices; | InvoiceId | CustomerId | InvoiceDate | BillingAddress | BillingCity | BillingState | BillingCountry | BillingPostalCode | Tots 1 2 3 5 8 91 10 11 12 13 14 | 151 16 | 171 18 19 20 21 22 | 23 24 | 25 2 | 2009-01-01 00:00:00 | Theodor-Heuss-Strae 34 | Stuttgart 4 | 2009-01-02 00:00:00 | Vllevlsveien 14 Oslo 8 | 2009-01-03 00:00:00 | Grtrystraat 63 | Brussels 14 | 2009-01-06 00:00:00 | 8210 111 ST NW | Edmonton 23 | 2009-01-11 00:00:00 | 69 Salem Street | Boston 37 | 2009-01-19 00:00:00 | Berger Strae 10 | Frankfurt 38 | 2009-02-01 00:00:00 | Barbarossastrae 19 | Berlin 40 | 2009-02-01 00:00:00 | 8, Rue Hanovre | Paris 42 | 2009-02-02 00:00:00 | 9, Place Louis Barthou | Bordeaux 46 | 2009-02-03 00:00:00 3 Chatham Street | Dublin 52 | 2009-02-06 00:00:00 | 202 Hoxton Street | London 2 | 2009-02-11 00:00:00 | Theodor-Heuss-Strae 34 Stuttgart 16 | 2009-02-19 00:00:00 | 1600 Amphitheatre Parkway | Mountain View | 17 | 2009-03-04 00:00:00 | 1 Microsoft Way | Redmond 19 | 2009-03-04 00:00:00 | 1 Infinite Loop | Cupertino 21 | 2009-03-05 00:00:00 | 801 Y 4th Street | Reno 25 2009-03-06 00:00:00 | 319 N. Frances Street Madison 31 2009-03-09 00:00:00 | 194A Chain Lake Drive | Halifax 40 | 2009-03-14 00:00:00 | 8, Rue Hanovre | Paris 54 | 2009-03-22 00:00:00 | 110 Raeburn Pl | Edinburgh 55 | 2009-04-04 00:00:00 | 421 Bourke Street | Sidney 57 | 2009-04-04 00:00:00 | Calle Lira, 198 | Santiago 59 | 2009-04-05 00:00:00 | 3, Raj Bhavan Road | Bangalore 4 2009-04-06 00:00:00 | Vllevlsveien 14 Oslo 10 | 2009-04-09 00:00:00 | Rua Dr. Falco Filho, 155 | So Paulo None | Germany | 70174 None Norway | 0171 None | Belgium | 1000 AB | Canada | TOG 207 MA | USA | 2113 None Germany | 60316 None | Germany | 10779 None | France 75002 None France | 33000 Dublin | Ireland None None | United Kingdom | N1 5LH None | Germany | 70174 CA | USA | 94043-1351 WA | USA | 98052-8300 CA | USA | 95014 NV | USA | 89503 WI | USA | 53703 NS | Canada | B3S 105 None | France 75002 None | United Kingdom | EH4 1HH NSW Australia | 2010 None Chile | None None | India 560001 None Norway | 0171 SP | Brazil | 01007-010 | 1.9 | 3.9 | 5.9 | 8.9 | 13. & | 0.9 | 1.9 | 1.9 13.9 | 5.9 | 8.9 | 13. & 10.9 | 1.9 | 1.9 | 3.9 | 5.9 | 8.9 | 13. E | 0.9 11.9 | 1.9 | 3.9 | 5.9 | 8.9 (Output limit exceeded, 25 of 412 total rows shown)
