1) Create the FINANCING_PLANS table and populate it with at least 5 (five) rows of data. Show all the SQL you used and the results returned by Oracle from executing your SQL after each SQL statement.
Ans. CREATE TABLE QUERY FOR FINANCING_PLANS TABLE
INSERT QUERIES FOR INSERTING 5 RECORDS IN FINANCING_PLANS TABLE
2) Add more rows as necessary to your VEHICLES table so that you have at least 50 (fifty) rows of data total. Execute a “SELECT COUNT(*) FROM vehicles” statement after you have added all your new 2 data. Show the INSERT SQL statements you used and the SELECT COUNT(*) statement and the results returned by Oracle from executing all your SQL after each SQL statement.
Ans. INSERT QUERIES FOR INSERTING 50 ROWS INTO VEHICLES TABLE
QUERY FOR RETRIEVING THE TOTAL NUMBER OF RECORDS IN VEHICLE TABLE
3) Create the SALESPERSONS table and populate it with at least 10 (ten) rows of data. You do not need to worry about a foreign key to the DEALERSHIPS table since you won’t be creating that table. Show all the SQL you used and the results returned by Oracle from executing your SQL after each SQL statement.
Ans. SALESPERSONS TABLE CREATE QUERY AND ITS RESULT
INSERT QUERIES FOR INSERTING 10 RECORDS INTO SALESPERSONS TABLE
4) Add more rows as necessary to your CUSTOMERS table so that you have at least 100 (one hundred) rows of data total. Execute a “SELECT COUNT(*) FROM customers” statement after you have added all your new data. Show the INSERT SQL statements you used and the SELECT COUNT(*) statement and the results returned by Oracle from executing all your SQL after each SQL statement.
Ans. INSERT RECORDS IN CUSTOMERS TABLE FOR INSERTING 100 RECORDS INTO TABLE.
COUNT RECORDS IN CUSTOMERS TABLE
5) Add more rows as necessary to your SALES table so that you have at least 200 (two hundred) rows of data total. Execute a “SELECT COUNT(*) FROM sales” statement after you have added all your new data. Show the INSERT SQL statements you used and the SELECT COUNT(*) statement and the results returned by Oracle from executing all your SQL after each SQL statement.
Ans. INSERT QUERY FOR INSERTING 200 ROWS INTO SALES TABLE
QUERY TO COUNT THE TOTAL NUMBER OF RECORDS INTO SALES TABLE
6) Create the SALES_FINANCINGS table and populate it with at least 200 (two hundred) rows of data (i.e. one per sale). Execute a “SELECT COUNT(*) FROM sales_financings” statement after you have added all your new data. Show the INSERT SQL statements you used and the SELECT COUNT(*) statement and the results returned by Oracle from executing all your SQL after each SQL statement.
Ans. CREATE SALES_FINANCINGS TABLE QUERY OUTPUT
QUERY FOR INSERTING 200 RECORDS INTO SALES_FINANCINGS TABLE
QUERY TO SHOW THE TOTAL NUMBER OF RECORDS IN SALES_FINANCINGS TABLE
7) Via a single SELECT query display the total count of sales, and the lowest, average, and highest sale price. Show the SQL statement you used and the results returned by Oracle from executing your SQL statement right after the statement.
Ans.
8) Via a single SELECT query display all customer IDs, names, and zip codes of customers having purchased 2 or more vehicles. Show the SQL statement you used and the results returned by Oracle from executing your SQL statement right after the statement.
Ans.
9) Via a single SELECT query display the institution and loan type of the financing plan that was used for the most sales. Show the SQL statement you used and the results returned by Oracle from executing your SQL statement right after the statement.
Ans.
10) Via a single SELECT query display the make of the vehicle involved in the most sales and all customers having purchased a vehicle of that make. Show the SQL statement you used and the results returned by Oracle from executing your SQL statement right after the statement.
Ans.
11) Via a single SELECT query display the total count of sales, by model and then by zip code, with the highest values first. Show the SQL statement you used and the results returned by Oracle from executing your SQL statement right after the statement.
Ans.
The post CREATE TABLE QUERY FOR FINANCING_PLANS TABLE appeared first on My Assignment Online.