Please provide solution as it is requested on the assignment. Thank you.

For the assigned problems, assume the Customer table exists as follows: cust id name 1 Smith 2 Mou 3 Golub 4 Chin 5 Harris 6 Bjorn 7 Kumar 8 Swenson credit_limit 10,000 15,000 5,000 10,000 15,000 10,000 5,000 12,000 balance state 7,000 TX 2,000 MD 0 MD 3,000 NY 10,000 MD 3,000 NY 4,000 TX 1,000 TX The primary key of Customer is cust_id. The following queries are executed from sites S1, S2, and S3: q1: SELECT FROM WHERE cust id, name Customer state = 'TX with access frequencies (per hour) from each site: Si = 0; S2 = 15; S3 = 0 92: SELECT FROM WHERE name, balance Customer state = 'MD' with access frequencies (per hour) from each site: Si = 10; S2 = 20; S3 = 0 93: SELECT FROM WHERE cust_id, name, balance Customer state = 'NY with access frequencies (per hour) from each site: Si = 5; S2 = 0; S3 = 10 94: SELECT FROM WHERE cust_id, balance, credit limit Customer credit limit > 11,000 with access frequencies (per hour) from each site: Si = 0; S2 = 35; S3 = 5 95: SELECT FROM cust_id, balance, credit_limit, state Customer 1 WHERE credit limit 11,000 with access frequencies (per hour) from each site: Si = 0; S2 = 35; S3 = 5 95: SELECT FROM cust_id, balance, credit_limit, state Customer 1 WHERE credit limit