Question: phpMyAdmin help : What do i need write down in the box so that it follows the instructions? Thank you Assignment Part A 1. Create

phpMyAdmin help :

phpMyAdmin help : What do i need write down in the box

so that it follows the instructions? Thank you Assignment Part A 1.

Create a table called students with the following columns: id(integer), name(varchar), address(varchar)

and age(integer) Use a query to 2. Fill up the table with

What do i need write down in the box so that it follows the instructions? Thank you

Assignment Part A 1. Create a table called students with the following columns: id(integer), name(varchar), address(varchar) and age(integer) Use a query to 2. Fill up the table with values for ages 20, 30, 15, 39, 20 3. Add a new student with age 31 and address: "150 W University Blvd". 4. Show the content of your table 5. Show the names of the students (only the names) 6. Show the addresses and ages of the students 7. Show the ids, names and ages of the students 8. Show the addresses of the students with ages 15, 30, 31 9. Sort the table by the 'age' column in ascending order 10. Sort the table by the 'id' column in descending order 11. Find the name and id of the youngest student. (don't use age X in your query) 12. Find the address and age of the oldest student. (don't use age X in your query) 13. Query the number of rows in the column of names 14. Query the sum of the elements in the age column 15. Query the average value of the different ages 16. Find the list of students with ages between 30 to 40, where 30 and 40 are inclusive 17. Delete the row which has age 39 18. Change age 15 to 25 19. Change the name of the student with age 25 to Moses 20. Change the name, address, and id of the oldest student

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!