AS-T8-Databases

Write the required SQL code for querying a database THISTABLE that prints out the sum of a numerical field THISFIELD.

(a)  

Write the required SQL code for querying a database THISTABLE that prints out the average of a field THISFIELD.

(a)  

Write the required SQL code for querying a database THISTABLE to find all data that have a field THISFIELD that starts with "A"

(a)  

complete the required SQL code for updating data in a table THISTABLE. Give the three key words, separated by commas (,).

_________ THISTABLE
___________THISFIELD = value
______________ condition;

(a)  

Write the required SQL code for deleting data from a table THISTABLE.

(a)  

Write the required SQL code for deleting an entire table THISTABLE

(a)  

Complete the required SQL code for adding data to a table THISTABLE. Give the two key words, separated by a comma.

__________ THISTABLE(field1, field2, field3)
__________________ (value1, value2, value3);

(a)  

Complete the required SQL code for creating an inner join between 3 tables - table1, table2, table3.

SELECT fieldnames
FROM _____________
ON table1.field1 = table2.field1
____________________
ON table2.field1 = table3.field1;

(a)  

Complete the required SQL code for creating an inner join between 2 tables - table1, table2.

SELECT fieldnames
FROM table1
(a)  

ON table1.field1 = table2.field1

Complete the required SQL code for changing the data type of one field

_____________________ tablename
___________ fieldname datatype;

(a)