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

SQL query questions

We offer the best custom writing paper services. We have answered this question before and we can also do it for you.

GET STARTED TODAY AND GET A 20% DISCOUNT coupon code DISC20

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.