- All Of These Assignments Are To Be Completed In Mysql Create The Sql Statement And Run 1 (104.8 KiB) Viewed 36 times
All of these assignments are to be completed in MySQL. Create the SQL statement and run.
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
All of these assignments are to be completed in MySQL. Create the SQL statement and run.
All of these assignments are to be completed in MySQL. Createthe SQL statement and run.
1. Create the following table with records 2. Run a function that will capitalize all the records in the NAME column. 3. Run a function that will remove all the capital letters from the BREAKFAST column 4. Run a function that will concatenate the NAME column and DINNER column 5. Run a function that will show the length of strings in the HOURS OPEN column 6. Run a function that will calculate the total of the AVERAGE PRICE column 7. Save your SQL statements in one file called assingment8.sql and upload to blackboard
1. Create the following table with records 2. Run a function that will capitalize all the records in the NAME column. 3. Run a function that will remove all the capital letters from the BREAKFAST column 4. Run a function that will concatenate the NAME column and DINNER column 5. Run a function that will show the length of strings in the HOURS OPEN column 6. Run a function that will calculate the total of the AVERAGE PRICE column 7. Save your SQL statements in one file called assingment8.sql and upload to blackboard