Question: Write SELECT statements that implement the following queries. ( 1 ) Find the evaluation texts and the full names of customers who provide these evaluations,

Write SELECT statements that implement the following queries.
(1) Find the evaluation texts and the full names of customers who provide these evaluations, and the evaluation rank score is greater than 3. There is no need to include customers who did not provide evaluations.
(2) Find the product number, price and manufacturer of all products where the price is greater than 5.00 and less than 10.00.
(3) Find the product number of all products that have at least 2 keywords.
(4) Find the customer number and full name (fname and lname) of all customers who live in Wollongong, NSW.

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!