Assignment on Database Management System 1

Running head: DATABASE MANAGEMENT SYSTEM
Database Management System
Name of the Author
Name of the University
Author Note

DATABASE MANAGEMENT SYSTEM
1
1. Show sums of line units for each invoice.
select inv_number, sum(line_units) as total from line group by inv_number;
2. Show the details of the products that do not have a value for the attribute v_code.
select * from product where v_code='';
3. Show the details of the invoices whose subtotal is greater than 24 but less than 76.
select * from invoice where inv_subtotal<76 and inv_subtotal>24;