Exercise: Data Manipulation and Querying
Explore practical exercises to master data manipulation and querying using SQL commands. You will insert records, update product prices, upgrade customer statuses, consolidate categories, and retrieve product details. This hands-on practice strengthens your skills with DML and DQL in managing real database scenarios.
We'll cover the following...
Let’s get some hands-on practice with DML and DQL commands using our OnlineStore database.
Question 1
Given the following structure of the Suppliers table:
Field | Type |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The Suppliers table stores detailed information about suppliers, including their contact details (such as email, phone, and address), as well as performance metrics like on-time delivery rate and average lead time. It helps track and evaluate suppliers involved in providing products to the store.
Insert a new supplier into the Suppliers table.
Name: Global Goods Inc. ...