Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Scenario 1
Table Customers:(cust)
Table Orders:(order)
These two tables will be joined on the columns id (table customer) and Cust_id (Table Orders)
Question 1. Write a SQL query to get all the customer who had placed orders with aggregated total order cost and total order count.
Return below columns
• Cust.id
• Cust.first_name
• Cust.last_name
• Cust.state
• Total_order_cost
• Total_order_count
Question 2. Write a SQL query to get the list of customers who hadn't place any orders before.
Return below columns:
• Cust.First_name
• Cust.Last_name
• Cust.Phone_number
Question 3. Write a SQL query to return Customer record with highest aggregated total_order_cost Return below columns:• Cust.id
Question 4. Write a SQL query to return Customer record with 2nd highest aggregated total_order_cost Return below columns:• Cust.id
Scenario 2
Note:
The employees table stores employee details. There will be a new record inserted whenever there is achange in the employee's details.
Question 5. Write a SQL Query to return all the employee details with latest record.
Scenario 3
The employees table stores employee's details. There are duplicated records captured in the table.
Question 6. Write a SQL Query to remove/delete the duplicate row and only keep one record per employee.
Using the sample shown below, create a Risk Information Sheet for at least five potential risks that might be encountered during the conversion. At least three of the five risks you choose should be project management related.
Additionally, it will periodically check the modification time of the routing table file and if it detects that it has changed, it will re-read it and send BGP UPDATEs reflecting the changes to all connected peers. This functionality is described i..
Write 10 SQL statements against the STUDENT schema you created for practice lab 1. Your statements should run error-free and should be valid.
Describe some techniques for gathering requirements to develop SQL queries. Provide an example using a business case.
List all the student Id and teacher Id where GPA is 3 or more than 3. List all the students of the teacher whose name is 'John Eric'. List student Id, name, and address of all the students whose date of birth is 1983. List all the Course Code where..
Develop a PL/SQL user-defined function ZIP_CODE_SALES_WINNER that returns the zip code with the largest total car purchases. Since there can be a tie with two or more zip codes, ensure that the lowest numeric zip code is returned.
Display the structure details for which the smallest total billable activity (time) has been performed in the last month - Display details of all employees (number, name) for whom billingrecords have been created when they are not identified as havi..
Display all columns and all rows from the Customer table. Display the ProductID, ProductNumber and ListPrice for all rows in the Product table.
Write a Select statement that returns four columns from the Invoices table, named Number, Total, Credits, and Balance
Discussing SQL Injection. Be sure to include ways to prevent this type of attack. Use at least two sources outside your text and course material for this paper
As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.
Create publication on your default instance of SQL server that creates transactional snapshot of the SUPPLIERS and PRODUCTS table located in Northwind database.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd