SQL query questions

1. Copy your d_cds table: CREATE TABLE new_dcds AS (SELECT * FROM d_cds); Using the DJs database. Please insert four new CDs of your choosing. You are to make up the data, be sure to follow the primary key rules and include cdnumber, title, producer, and year. Use an explicit INSERT statement to add each CD to the new_dcds table. ─ ─ ─ Include screenshots of each INSERT statement Explain what explicit INSERT means After inserting, run a SELECT * to ensure your work 2. Copy your d_clients table: CREATE TABLE new_dclients AS (SELECT * FROM d_clients); Please add two new clients to the new_dclients table. You may use either an implicit or an explicit INSERT. You are to make up these two new clients, please include the following for each: clientnumber, firstname, lastname, phone, email. ─ Include screenshots of each INSERT statement ─ After inserting, run a SELECT * to ensure your work 3. Copy your d_events table: CREATE TABLE new_devents AS (SELECT * FROM d_events); Please add the two new client’s (from problem 2) to the new_devents table. You are to make up the events for both clients, including: ID, name, eventdate, description, venueid, packagecode, themecode, clientnumber. You will notice that the new_devents table also requires a cost, however for these two new clients, they are not given a cost yet. You must decide how to handle this. ─ ─ Include screenshots of each INSERT statement Explain how you handled no costs for your new clients After inserting, run a SELECT * to ensure your work 1. Using the Fast Foods database. Make a copy of the f_fooditems, name it new_ffooditems. ─ Select two food items to UPDATE the price. Select the price. ─ Make these changes in the new_ffooditems table. ─ Run a Query and include a screenshot of pre-change price data ─ Include screenshots of each INSERT After updating, run a SELECT * to ensure your work