Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases New Opportunities For Connected Data

Authors: Ian Robinson, Jim Webber, Emil Eifrem

2nd Edition

1491930896, 978-1491930892

More Books

Students also viewed these Databases questions

Question

How do organisations go about benchmarking?

Answered: 1 week ago

Question

5. What information would the team members need?

Answered: 1 week ago

Question

Which team solution is more likely to be pursued and why?

Answered: 1 week ago