Question: Write down the SQL statement for each question. You dont need to show the output table A. Show all data in each of the tables
Write down the SQL statement for each question. You dont need to show the output table
A. Show all data in each of the tables (each table separately)
B. List the Name, and email of all customers.
C. List the Name, and email for all customers with a FirstName of Nikki (assume there are multiple customers with the name Nikki).
D. List Name, and Email of all customers whose f name starts with 'B'.
E. List the Name, and Phone of all customers whose name includes the characters 'cat'.
F. Count the number of customers.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
