Write SQL queries for the following: (submit the query and a screenshot of the results) 1. Display the maximum total_payment of invoices. (5 Points) 2.
Write SQL queries for the following: (submit the query and a screenshot of the results)
1. Display the maximum total_payment of invoices. (5 Points)
2. List the number of VENDORS in each state and the number should be greater than 5. (20 points)
3. List the vendor_ID, vendor NAME for those who have not payed an invoice. (15 Points)
4. List the vendor_ID, vendor NAME and the number of invoices for each vendor . List only those that have more than 2 invoices. (20 Points)
5. List the invoice_id for the highest invoice value. [Use sub-query. Do not hard-code the value] (20 points)
6. Write a SQL query to create a sequence MYSEQ, that starts from 10 and increment by 5. Display the next value in the sequence. (Submit two queries. One for creating the sequence and the other for displaying the next value.) (20 points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started