The following tables form part of a database held in a Relational Database Management System for a printing company that handles printing jobs for book publishers:
Formulate the following queries using SQL:
(a)
(1) List all publishers in alphabetical order of name.
(2) List all printing jobs for the publisher 'Gold Press'.
(3) List the names and phone numbers of all publisher who have a rush job (jobType = 'R').
(4) List the dates of all the purchase orders for the publisher 'Gold Press'.
(5) How many publisher fall into each credit code category?
(6) List all job type's with at least three printing jobs.
(7) List the average price of all items.
(8) List all items with a price below the average price of an item.
(b) Create a view of publisher details for all publisher who have a rush printing job, excluding their credit code.

Question

The following tables form part of a database held in a Relational Database Management System for a printing company that handles printing jobs for book publishers:
  Formulate the following queries using SQL:
(a)
 (1) List all publishers in alphabetical order of name.
(2) List all printing jobs for the publisher 'Gold Press'.
(3) List the names and phone numbers of all publisher who have a rush job (jobType = 'R').
(4) List the dates of all the purchase orders for the publisher 'Gold Press'.
(5) How many publisher fall into each credit code category?
(6) List all job type's with at least three printing jobs.
(7) List the average price of all items.
(8) List all items with a price below the average price of an item.
(b) Create a view of publisher details for all publisher who have a rush printing job, excluding their credit code.

Quizplus · Accepted Answer

The Answer of The following tables form part of a database held in a Relational Database Management System for a printing company that handles printing jobs for book publishers:
  Formulate the following queries using SQL:
(a)
 (1) List all publishers in alphabetical order of name.
(2) List all printing jobs for the publisher 'Gold Press'.
(3) List the names and phone numbers of all publisher who have a rush job (jobType = 'R').
(4) List the dates of all the purchase orders for the publisher 'Gold Press'.
(5) How many publisher fall into each credit code category?
(6) List all job type's with at least three printing jobs.
(7) List the average price of all items.
(8) List all items with a price below the average price of an item.
(b) Create a view of publisher details for all publisher who have a rush printing job, excluding their credit code.

The Following Tables Form Part of a Database Held in a Relational