Question: 1. Queries in Relational Algebra and SQL Consider the order database of a retail company: customers (id.customer -> customerName, address, PostalCode, contact) products (id. Product

1. Queries in Relational Algebra and SQL Consider the order database

1. Queries in Relational Algebra and SQL Consider the order database of a retail company: customers (id.customer -> customerName, address, PostalCode, contact) products (id. Product -> ProductName, price, quantityStock) salespeople (id.Salesperson -> SalespersonName, contact, commission) orders (id.Order -> id.Customer, id.Salesperson, date) order_lines (id.Order, id.Line -> id. Product, quantity) Express the following queries in SQL. Also avoid the clauses WITH, TOP and LIMIT: 1.1. Using the UNION operator, what are the names of customers who ordered 'X' and 'Y' products. 1.2. Using the IN clause, what are the names of the sellers who order 'X' and 'Y' products? 1.3. What are the names of the products that are ordered more than the average order (quantity x price) of the products

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!

1. Queries in Relational Algebra and SQL Consider the order database of a retail company: customers (id.customer -> customerName, address, PostalCode, contact) . products (id.Product -> ProductName,...

1. Queries in Relational Algebra and SQL Consider the order database of a retail company: customers (id.customer -> customerName, address, PostalCode, contact) products (id.Product -> ProductName,...

Database Design Report and Implementation - Please ignore requirement for screenshot, just need assistance with the actual SQL queries so I can insert them into the data myself for the output....

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

I need assistance with the following SQL queries. Northwind SQL Queries I need assistance with questions 20 through 32. I was able to get started on this assignment but now I'm stuck. Please help! /*...

Northwind SQL Queries I need help with questions 20 through 32. I was able to get started on this assignment but now I'm stuck. Please help! /* DB Design & SQL Northwind SQL Lab Write the SQL queries...

HOMEWORK Questions (for each of the following 5 questions, create both SQL and Cypher query versions (showing resulting output for each) -- 2 pts each, so 20 points in total): Show all products...

For the questions below, use the W3Schools customer orders database. You need to submit thoroughly tested SQL statements. For your convenience and reference, relevant data model is attached as a PDF...

For the Pizza Delivery Shop DB, (see Appendix), write SQL queries to answer each of the following questions. a) List all the last names, phone numbers and zip codes of the customers. b) List...

Assume Delicious Desserts, Inc., purchased conveyor-belt machinery. Classify each of the following expenditures as a capital expenditure or an immediate expense related to machinery: a. Sales tax...

Using the information in P22-1B, compute the overhead controllable variance and the overhead volume variance. Data from P22-1B Korte Corporation manufactures a single product. The standard cost per...

Please provide the answer to this general accounting question with proper steps. Johnson Company produces products X and Y from a joint process. Data for the current period is as follows: > Product...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

2. Why have Starbucks customer satisfaction scores declined? Has the companys service declined or is it simply measuring satisfaction the wrong way?

3. What effect does the RD membership program have on the brand and value perception of its local customers in Hong Kong and its full-paying hotel guests and diners? How could the hotel address these...

5. How could negative server attitudes towards RD customers be handled?