I need someone to help me with these codes: ( I broke them into separate posts,

Question

I need someone to help me with these codes: ( I broke them into separate posts, please do check the other posts.)
As for the tables names, just please state "table name" in the code.

Code:

A. Show all data in each of the tables.
B. List the Phone and LastName of all customers.
C. List the Phone and LastName for all customers with a FirstName of ‘ Nikki’.
D. List the Phone, DateIn, and DateOut of all orders in excess of $ 100.00.
E. List the Phone and FirstName of all customers whose first name starts with ‘ B’.

Explanation / Answer

A)select * from table_name B)select phone,lastname from table_name C)select phone,lastname from table_name where firstname='nikki' D)select phone,datein,dateout from table_name where order>100 E)select phone,firstname from table_name where firstname LIKE 'B%'

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---