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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!