Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Student _ No Student _ Name Student _ Surname Student _ Phone Student _ Addres 4 0 1 0 0 1 0 5 6 Blake

Student_No Student_Name Student_Surname Student_Phone Student_Addres
401001056 Blake Pillay 071123456758 first street
401002567 Slee Johnson 0724567890135 Musgrave Road
401006084 Aphelele Carson 073789456087 Park Avenue
401067090 Quade Davies 074776904090 Park west
401003897 Mxolisi Van de Merwe 076094594154 Florida Road
Suppose you now want to manipulate the data from the table above. Write the necessary SQL code of the following:
1. List all the records in the table.
2. List all the records that have an empty value for the Student_No field.
3. List all the records where Student_Surname has a letter o.
4. Return all information associated with the Student_No 401003897.
5. Delete the student table.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions