requesting assistance for easy sql assignment. no time with jobs. thanks.
Added by Lisa R.
Step 1
First, identify the purpose of the SQL assignment. What is the goal or objective of the assignment? Is it to retrieve data from a database, modify data, or create a new database? Show more…
Show all steps
Your feedback will help us improve your experience
Patina Herring and 64 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Write the following queries in relational algebra, using the university schema. a. Find the titles of courses in the Comp. Sci. department that have 3 credits. b. Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result. c. Find the highest salary of any instructor. d. Find all instructors earning the highest salary (there may be more than one with the same salary). e. Find the enrollment of each section that was offered in Autumn 2009. f. Find the maximum enrollment, across all sections, in Autumn 2009. g. Find the sections that had the maximum enrollment in Autumn 2009.
Sri K.
Queries: Write the following SELECT statements that return the following to test your work. Write these as CREATE VIEW statements. (Concatenate names with a blank between first and last name) a. Car Seller List: Company name, contact name, street, city, state, zip, phone, fax, ordered by Company Name. b. Vehicle Sales List: Invoice Number, Salesperson name, Approved by Name, VIN, Make, Model, Trade-In Vin, Trade-In Make, Trade-In Model, Selling price, Shipping, Discount, Trade-In Allowance, Subtotal, Taxes, Misc, Total Selling Price (Order by Invoice Number) c. Vehicle Purchase List: Purchase Order Number, Company Name, Contact Name, VIN, Make, Model, Sales Amount, Shipping, Taxes, Total Price, Manager Named. d. Service Invoice List: Invoice Number, Customer Name, VIN, Make, Model, Mileage, Total Service Charge, Total Parts Charge, Total Charges, Taxes, Misc, Total Charges
Aarya B.
Please help me with these SQL queries 1. Give a list of customers (IDs and names) who have purchased multiple items, but all of which were the same color. Multiple items means more than one sale item. Use what you learned in the previous problem about counting colors. 2. Give a list of products and their list prices for sneakers whose list price is less than the average for flats. Only show product names and prices. 3. What is the most expensive sale item (SalePrice * Quantity) ever made and to whom was it made (first and last name)? Name the column LargestItemSale. (Use a max subquery in the WHERE clause.) Manufacturer: - ManufacturerID - ManufacturerName - Address1 - Address2 - City - State - PostalCode - Country - Phone - Fax - Contact - URL Customer: - CustomerID - FirstName - LastName - StreetAddress - City - State - PostalCode - Country - Phone Product: - ManufacturerID - ProductID - ProductName - Composition - ListPrice - PostalCode - Gender - Category - Color - Description - Phone - Fax - Contact - URL SaleItem: - SaleID - ProductID - ItemSize - SaleID - Quantity - SalePrice InventoryItem: - ProductID - ItemSize - QtyOnHand PurchaseItem: - ProductID - ItemSize - PurchaseID - Quantity - PurchasePrice Sale: - SaleID - SaleDate - CustomerID Purchase: - PurchaseID - PurchaseDate - EmployeeID - ExpectedDeliveryDate - ManufacturerID - Shipping Employee: - EmployeeID - FirstName - LastName - Address - City - State - ZIP - Phone - ManagerID - SSN - EmailAddress - HireDate Shipping: - ShippingID - EmployeeID - ShippingDate SalaryEmployee: - EmployeeID - Salary WageEmployee: - EmployeeID - Wage - MaxHours
Akash M.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Watch the video solution with this free unlock.
EMAIL
PASSWORD