Need someone to complete SQL homework problems. Immediate work and hire (Within next 3 hours)

Need someone to complete SQL homework problems. Immediate work and hire (Within next 3 hours)

Cancelled

Job Description

Hello,

I need an SQL expert to help me with some of my SQL homework questions. These questions are simple and any sql expert should easily be able to help me answer them.

put 4+7=11 in your subject line or your application will be ignored.

You will be using oracle to check the answers, I have an online oracle student workstation

I will pay you $5 for 5 questions completed.

Examples of some questions you will be asked to complete:


Question 1. Code a SQL statement to total all the customers who were
referred by another customer

A.
SELECT SUM(referred)
FROM customers;

B.
SELECT COUNT(referred)
FROM customers;

C.
SELECT COUNT(*)
FROM customers;

D.
SELECT COUNT(referred)
FROM customers
WHERE referred IS NULL;




Question 2. What's the average retail price of the books (for unique prices within
the books table) that have a cost between $10-$30

A.
SELECT AVG(DISTINCT retail) "Average Unique Retail Price"
FROM books
WHERE retail >= 10
AND retail <= 30;

B.
SELECT AVG(retail) "Average Unique Retail Price"
FROM books
WHERE retail >= 10
OR retail <= 30;

C.
SELECT SUM(DISTINCT retail) "Average Unique Retail Price"
FROM books
WHERE retail >= 10
AND retail <= 30;

D.
SELECT SUM(retail) "Average Unique Retail Price"
FROM books
WHERE retail >= 10
OR retail <= 30;




Question 3. Display a list of publishers (by name) and the number
of books they publish

A.
SELECT name, SUM(pubid)
FROM publisher JOIN books USING (pubid)
GROUP BY publisher;

B.
SELECT name, COUNT(pubid)
FROM publisher JOIN books USING (pubid)
GROUP BY pubid;

C.
SELECT name, COUNT(*)
FROM publisher JOIN books USING (pubid)
GROUP BY pubid, name;

D.
SELECT name, COUNT(pubid)
FROM publisher JOIN books USING (pubid)
GROUP BY name;

Other open jobs by this client