Use a provided template to practice using built-in SQL functions to INSERT data

Use a provided template to practice using built-in SQL
functions to INSERT data into a new table and select data from tables for
reporting purposes, using the appropriate primary and foreign keys.
For this final assessment, you will learn about some SQL
functions that are useful for working with strings, dates, and numbers.
Assessment Instructions
Overview
For your final assessment, you will practice using built-in
SQL functions to INSERT data into a new table and select data from tables for
reporting purposes.
Note: Remember to design the new table with the
appropriate primary and foreign keys so you can relate these records to
volunteers in the PERSON table. Each table should include an ID column as the
primary key.
Instructions
Your assessment will be scored on the following criteria.
Use the Weekly
Solutions Submission Template [DOCX] to submit your assessment.
Create
a new table named USERS for your volunteer database. The USERS table will
be used to store a USERNAME for each volunteer.
Use an
INSERT INTO statement with a subquery containing a SQL string function to
create user names for the volunteers based on their legal names and insert
them into the table.
Hint:
Take a look at the CONCAT() and SUBSTRING() functions.
Use
SQL aggregate functions such as COUNT(), MIN(), and MAX() and write three
queries to report on various aspects of the organization’s volunteers.
Save
your SQL statements for Steps 1–3 to a text file using the MySQL
tee command and document the process with screenshots.
Review
and reflect on all of the work you have completed this quarter.
Briefly
summarize in 2–3 paragraphs the key components of the volunteer
database.

The post Use a provided template to practice using built-in SQL
functions to INSERT data appeared first on blitzarchive.com.