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 First Name, Last Name, Email, and Phone, from the Customers table. What is the telephone number for Jennifer Peterson? 1 2 3 4 5 Select FirstName, LastName, Email, Phone From Customers; + | FirstName | Last Name | Email | Phone + | Lus | Gonalves | luisgembraer.com.br | +55 (12) 3923-5555 | Leonie | Khler | leonekohler@sur feu. de +49 0711 2842222 | | Franois | Tremblay | ftremblay@gmail.com | +1 (514) 721-4711 | | Bjrn | Hansen | bjorn. hansen@yahoo.no | +47 22 44 22 22 | | Frantiek | Wichterlov | frantisekw@jetbrains.com | +420 2 4172 5555 | | Helena | Hol | hholy@gmail.com | +420 2 4177 0449 Astrid | Gruber | astrid, gruber@appleat | +43 01 5134505 | | Daan | Peeters | daan_peeters@apple.be | +32 02 219 03 03 | | Kara | Nielsen | kara.nielsen@jubii.dk | +453 3331 9991 | Eduardo | Martins | eduardo@woodstock.com.br | +55 (11) 3033-5446 | Alexandre | Rocha | alero@uol.com.br | +55 (11) 3055-3278 | | Roberto | Almeida | roberto. almeida@riotur. gov.br | +55 (21) 2271-7000 | | Fernanda Ramos | fernadaramos4@uol.com.br | +55 (61) 3363-5547 Mark | Philips | mphilips12@shaw.ca | +1 (780) 434-4554 | | Jennifer | Peterson | jenniferp@rogers.ca | +1 (604) 688-2255 | | Frank | Harris | fharris@google.com | +1 (650) 253-0000 | | Jack | Smith | jacksmith@microsoft.com | +1 (425) 882-8080 | Michelle Brooks | michelleb@aol.com | +1 (212) 221-3546 | | Tim | Goyer | tgoyer@apple.com | +1 (408) 996-1010 | Dan | Miller | dmiller@comcast.com | +1 (650) 644-3358 | | Kathy | Chase | kachase@hotmail.com | +1 (775) 223-7665 | Heather | Leacock | hleacock@gmail.com | +1 (407) 9997788 | | John | Gordon | johngor don22@yahoo.com | +1 (617) 5221333 | Frank | Ralston | fralston@gmail.com | +1 (312) 332-3232 | | Victor | Stevens | vstevens@yahoo.com | +1 (608) 257-0597 | (Output limit exceeded, 25 of 59 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

Creating A Database In Filemaker Pro Visual QuickProject Guide

Authors: Steven A. Schwartz

1st Edition

0321321219, 978-0321321213

More Books

Students also viewed these Databases questions

Question

What are the purposes of collection messages? (Objective 5)

Answered: 1 week ago