Continue to work with your partner and the script you created in Assignment 1a.
PLEASE SUBMIT A RUNNING SCRIPT WITH NO ERRORS TO ME. IF THE SCRIPT DOES NOT RUN COMPLETELY, I WILL ONLY MARK UNTIL WHERE IT RUNS OR THE OUTPUT(S) I CAN SEE. I WILL NOT CORRECT YOUR SCRIPT OR MARK THE CODE AFTER THE STATEMENT CAUSING THE ERROR, EVEN IF THEY ARE CORRECT. SO IF SOMETHING DOES NOT WORK IN YOUR SCRIPT, REMOVE THE CODE BUT PLEASE GIVE ME AN ERROR FREE COMPLETELY RUNNING SCRIPT.
You have created a table of your choice with relevant fields. Now you want to retrieve useful information from this table. Add relevant SELECT statements at the end of the Assignment 1a, clearly commenting the functionality of each of them. Think of what type of queries will be made on the table data in a real life scenario and come up with associated SELECT statements for them. You can insert more relevant records in the table if you require doing so.
I want to see at least 15 SELECT statements, satisfying the criterion given below. A statement can include one or more than one criteria.
i. An exact match involving character data – recollect does not involve wildcard characters, like % and _
ii. Use of NOT LIKE comparison operator, for an inexact match, using wildcard character %
iii. Use of NOT LIKE comparison operator, for an inexact match, using wildcard character _
iv. Use of at least two relational operator (, < =, <=, <, !=) in the same or different statements
v. Use of all Boolean operators (AND, OR, NOT) in the same or different statements
vi. Use of the BETWEEN comparison operator
vii. Use of a string function
viii. Use of a numeric function
ix. Use of IN() or NOT IN() comparison function
x. Use of display/alias names
xi. Displaying only some fields
xii. Displaying all fields of the table
xiii. Use of order by using ASC
xiv. Use of order by using DESC
xv. Order by more than one fields
xvi. Use of limit clause displaying some records including record 1
xvii. Use of limit clause displaying some records in the table, not including record 1
