SQL Query Example 07191424

Download Solution: Click to Download Solution Solution File Name: SQLQueryExample07191424.docx Unzip Password: prestobear.com ########1.Print the name(s) and sid(s) of the student(s) enrolled in more than three classes in Fall 2016. ########2.Find the names of students who are enrolled in the maximum number of classes. ########3.Print… Read More

Sample SQL Queries 07061055

Download Solution: Click to Download Solution Solution File Name: SQLQueries07061055.docx Unzip Password: prestobear.com 1. List all items that sold for less than cost in the month of December. Hint: Use the function MONTH(date) to return the month of a date. Question1 ItemID Description Category Cost… Read More

SQL Queries Question 06291113

Download Solution: Click to Download Solution Solution File Name: SQLQueriesQuestion06291113.docx Unzip Password: prestobear.com Given the database description below: Tb_Supplier(Supp_ID, Name, City, State) Tb_Consumer(Con_ID, Name, City, State) Tb_Product(Prod_ID, Name, Product_Category, Product_Line, Product_Packaging) Tb_Offers(Supp_ID, Prod_ID, Quantity, Price) Tb_Requests(Con_ID, Prod_ID, Quantity, Price) Tb_Transactions(Tran_ID, Supp_ID, Con_ID, Prod_ID, Quantity, Price)… Read More

Sample SQL Queries 06271047

Download Solution: Click to Download Solution Solution File Name: Nat7a_SQL_1CCC.doc Unzip Password: prestobear.com Problem: Consider the following relational database that Best Airlines uses to keep track of its mechanias, their skills, and their airport locations. Mechanic number (MECHNUM), airport name (AIRNAME), and skill number are… Read More

Sample SQL Queries 06271025

Download Solution: Click to Download Solution Solution File Name: Na7a_0215_1CCCPB.docx Unzip Password: prestobear.com Consider the following relational database for Carnival Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A “cruise” is a particular sailing of a ship on a specific date. For… Read More

Oracle SQL Queries 06151146

Download Solution: Click to Download Solution Solution File Name: Task3_12AAA.doc Unzip Password: prestobear.com Problem: a. A Trigger which automatically stores in a separate table called ‘ExcellentSale’ the Sales Agent name, car model and manufacturer name, each time the agreed price of a SalesTransaction is more… Read More

Oracle SQL Queries 06151134

Download Solution: Click to Download Solution Solution File Name: Task2_123AAA.doc Unzip Password: prestobear.com Problem: a.Write a stored procedure that displays the contact details of viewing parties who haven’t visited the dealership for over six months. For organisations, include the organisation name in the output. For… Read More