Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!


Ameritech College of Healthcare Lesson 4 SQL Queries Report

Ameritech College of Healthcare Lesson 4 SQL Queries Report

I’m working on a mysql exercise and need a sample draft to help me understand better.


For your Lesson 4 Hands-On, you will be working with your new knowledge on SQL queries. This Hands-On will be graded, so be sure you complete all requirements. Please read through the below setup instructions before starting your project.


This Hands-On is structured into two parts, and each part may ask you to run multiple queries. After each query, please take a screenshot of the MySQL output and add it to a Word document (or an equivalent) and name this file SQL-HandsOn4. This way, you will be able to submit your answers to each part all at once.

Now you are ready to get started! Good luck!

Part 1

Run the following queries:

  1. Create a view named “initialCustomers” that shows the first name, last name, and email address of customers that have an id of less than 100. Once that is complete, select and view your newly created view.

Part 2

Complete the following:

Create a table named “ProductList”. Include the following columns:

  • ProductId
  • ProductName
  • Price
  • DateAdded
  • EmployeeSupportId

Include the following requirements:

  1. Every product should have an automatically generated id number that should be unique for each product.
  2. Give each column a data type that would apply
  3. Give the DateAdded column a default value for the current local time.
  4. All columns CANNOT be null.

Next, insert one product into the table following the given guidelines when the table was created. When inserting the data, don’t include the ProductId or the DateAdded. Finally, run a query to see the single product in your table.

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Fox Writers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Fox Writers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Fox Writers is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Fox Writers, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.