Write the set of SQL commands necessary to insert the data into the CUSTOMER table you created in Problem 16, as illustrated in Figure P8.16. Problem 19: Write the set of SQL commands necessary to insert the data into the INVOICE table

Write a PL/SQL Programming block to do below actions 2.Before you work on Quesiton 2 , please create a table because you will be inserting numbers in thisMessages tableCREATE TABLE messages( RESULTS NUMBER)Run below query to see if there is any data :SELECT * FROM MESSAGES

Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…

Practice Question 1. Assume that the Users table has a plenty of records but only three colums: UserID, FirstName and LastName. Write the following: a) Write an SQL query to show the top 5 records of the Users table.  (in order to test it populate your table with more than 5 records) in the PHP file and to display the result in well-readable format (table preffered) in the browser using parameters. b) Write a SQL query in the  PHP file  that will print details of all users excluding those with the FirstName “Will” and “Michael” from the Users table and to display the result in well-readable format (table preffered) in the browser using parameters. Hint: you can either write all your code in the same file or use two different files