Create the following tables Table 1 (CLIENT_MASTER) Table II (SALE_ORDER) 1. 2. 3. Client No C00001 C00002 C00003 C00004 C00005 C00006 4. 5. Order No 019001 019002 046865 019003 046866 019008 Write SQL commands for the following: Order Date 12-Jan-13 25-Jan-13 18-Feb-13 03-Apr-13 20-May-13 24-May-13 Name SMITHA JAIN VANDANA RAO PREM PUJARI BASU NATH RAVI SHANKAR ROOPA Data for Client_Master Client No C00001 C00002 C00003 C00001 C00004 C00005 City Mumbai Chennai Mumbai Mumbai Delhi Mumbai Data for Sale Order Salesman No 500001 S00002 S00003 S00001 S00002 S00004 Pincode 400054 780001 400057 400056 100001 400050 Dely_Date 20-Jan-13 27-Jan-13 20-Feb-13 07-Apr-13 07-Apr-13 26-May-13 Bal due 15000 0 5000 0 2000 0 Order_Status In process Cancelled Fulfilled Fulfilled Cancelled In process List all details from the client_master table for clients whose Bal_due = 0. Update table client_master, Change city of Client_no C00004 to Jaipur. Retrieve records of clients residing in Mumbai. Find the name and address of customer who has placed Order_no '019003' and 'O19002' respectively. List the client_no, name, city and pincode of clients whose Order_status is "In process".

My other instruction for SQL says: Create and test a stored procedure called checkin_transaction that processes a “checkin” transaction. When a book is checked in, the corresponding CHECKOUT record is updated to show the date it was checked in, and the Pat_ID attribute in the BOOK table is updated to NULL.  The entire transaction (starting with START TRANSACTION; and ending with COMMIT;) should be in between the BEGIN and END statements of the stored procedure.  You should be able to call the procedure with a statement like this, passing the values of the Book_Num, Pat_ID, and Check_In_Date to the procedure:   CALL checkin_transaction(5243, 1170, ‘2017-04-30’) Do you guys know how?

C++ Nested loops: Print seats.   Given numRows and numColumns, print a list of all seats in a theater. Rows are numbered, columns lettered, as in 1A or 3E. Print a space after each seat, including after the last. Ex: numRows = 2 and numColumns = 3 prints:1A 1B 1C 2A 2B 2C #include <iostream>using namespace std; int main() {   int numRows;   int numColumns;   int currentRow;   int currentColumn;   char currentColumnLetter;    cin >> numRows;   cin >> numColumns;    /* Your solution goes here  */    cout << endl;    return 0;}

Write the SQL10. 1/   Drop the STORE table   2/ Drop the PURCHVW view

. Write a T-SQL correlated subquery selecting the store code, store name, store ytd sales from the store table where the store code matches the selection result of the max store code from the store table where the store code matches.   /* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE VALUES('5','Mr.','Smith','Robert','L','11/23/1959','GEN','3'); INSERT INTO EMPLOYEE…