Assignment Solution @ Assignment Help on Fiverr.com
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 the age difference between the oldest and youngest student(s) per…
Download Solution: Click to Download Solution Solution File Name: GetawayHolidaysSQLQueries.docx Unzip Password: prestobear.com Task 1 a. Display the name of the client who has made the most reservations with Getaway Holidays b. Display the name of the client who has booked the reservation for the longest period c. Display the Room no, Room type, Room…
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 ListPrice SalePrice OrderDate 8776 Wrench TOOL $4.75 $5.50 $5.00 12/3/2015…
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) 1) Product categories and number of products in each category?…
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 all unique fields. SIZE is an airports size in acres….
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 example, the seven-day journey of the ship Pride of Tampa…
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 than 20% of the car’s asking price. b. A Trigger…
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 international guests, include their country in the output. b.Write a…
Download Solution: Click to Download Solution Solution File Name: Task1_234AAA.doc Unzip Password: prestobear.com Problem: Do the queries for: a. Display the name of the customer who has purchased the most cars from Archie’s Luxury Motors. b. For each sales agent, display the total number of sales they have made thus far. Order by number of…