1)Using the BETWEEN operator, write a query that will list all details about all

Question

1)Using the BETWEEN operator, write a query that will list all details about all orders that were placed during the period of September 3rd thru September 5th of 1998.

2)
Using a NATURAL JOIN method, write a query that will list the customer number, last name, and first name for every customer who currently has an order on file for an iron.

3)
Write a query that will display the customer number, first name, and last name for every customer with a balance greater than $50. Display the first and last name as a single column and provide an alias for the column.

Explanation / Answer

1) select orders from Table_A where Date between '1998/09/03' and '1998/09/05'

2)select customer number, lastname, and firstname from Table_A NATURAL JOIN Table_B

ON Table_A . customer number = Table_B . customer number
Where order =iron

3) select customer number, (rtrim(firstname)+ ' ' + trim(lastname)) as fullname from Table_A where balance > 50

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.