- Write out an SQL statement that creates a table called members in your mydatabase database to store information about the members of a book club. Store the following data for each person: first name, last name, age, and the date they joined the club. Insert the following five imaginary people into this table:
❑ Jo Scrivener, aged 31, joined September 3, 2006
❑ Marty Pareene, aged 19, joined January 7, 2007
❑ Nick Blakeley, aged 23, joined August 19, 2007
❑ Bill Swan, aged 20, joined June 11, 2007
❑ Jane Field, aged 36, joined March 3, 2006
2.Write a SQL code to query the table you created in Exercise 1, displaying the details of all club members under 25 years of age.
3.Upload all the SQL code (create and insert statements for #1 and query for #2).
Look at sakila-schema.sql for examples on how to write Create Table statements. Look at sakila-data.sql to see how to write Insert statements.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post sql exercise appeared first on Custom Nursing Help.