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!
Complex SQL Queries
Write and run SQL statements to complete the following tasks
1. Show sums of line units for each invoice.2. Show the details of the products that do not have a value for the attribute v_code.3. Show the details of the invoices whose subtotal is greater than 24 but less than 76.4. Show the details of the invoice who has the minimum subtotal.5. Show the codes and names of the vendors who supplied products.6. Using EXCEPT show the codes of the vendors who did not supply any products.7. Using 'NOT IN' show the codes and names of the vendors who did not supply any products.8. List the names and codes of vendors and the number of products each vendor has supplied, i.e. vendor XXX has supplied xxx products, and vendor YYY has supplied yyy products etc.9. Show the details of the employees who are located in area code 615.10. Using inner join, list the details of the products whose line price is greater than 99.
You are required to submit:
1. The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file. If you type .echo on at the SQLite3 Command Line, SQLite will output your SQL statement with the results of the query making it easy to copy and paste both.
2. The screenshots of the results of the SQL statements which are to be copied from your SQLite3 Command Line and pasted into your submission file immediately after you execute the SQL query. If you used an output file please submit only the output file.
Verified Expert
The task of the assignment is to query the given SQLite database.The assignment contains more than 10 question for which queries are written and the output are documented. The assignment involves query based on except, in, not in and inner join. The queries are executed in the SQLite database.
Produce a diagram showing schema and the partial and transitive dependencies in your 1NF. b. Produce a diagram showing table schema and any transitive dependencies in your 2NF
What could have and should have been done to prevent the breaches? What could have and should have been done to mitigate the resulting damage?
for this assignment use the following database schema ltbrgt ltbrgt1 patientpatientid name dob ltbrgt ltbrgt2
Delete the NON_SP_GOOD table from the Premiere Products database.
Create the procedure in SQL Developer - Run the procedure by using the following block to add the MEMBER column: BEGIN dyn_addcol_sp('member','bb_shopper','CHAR(1)'); END;
Describe the meaning of the keyword EXISTS. Describe how any and all relate to EXISTS and NOT EXISTS. Write a query which will display names of any customers who are interested in all artists.
A number of new foods have been entered into the diet database. Provide a list of all the foods that has not been consumed by any people.
Look at your Book how they have done. Mention, Fully Functional Dependency and No Transitive Dependency - Tables implemented and the Create SQL statement Copied in the report
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.
List the movies which have more than one director. Include the year, title, last and first name of directors. Sort the output by last name within title. (use subquery)
Write a stored procedure that displays the contact details of clients who does not have any heart conditions or Acrophobia - Write a stored function
Write an SQL query that you would use to search for any books by J.J. Parsons in a table called BOOKS, where author's names are stored in a field called Title.
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