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
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
