Question: 3. Write a SQL statement to create a table to store frve firld inclusive of text. mumbers and date. 4 marke 4. Insert four records

 3. Write a SQL statement to create a table to store

3. Write a SQL statement to create a table to store frve firld inclusive of text. mumbers and date. 4 marke 4. Insert four records into same table 4 marks 5. Wne a SQL statement to select all ficld from the table. 2 mark 6. Derelop a query extracting three fields, mecting a single condition, and corted 4 marks 7. Update the table increasing the numenc value by 10%6 that meets a condition 4 maks 8. Extract data using the one of the following and/orot furction. 3 mark 9. Use au ageregate finction to extract data from the table daat meets a copdanion 4 marko

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!