[Solved] RelationalDatabase Assignment 1b

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.

1. An exact match involving character data recollect does not involve wildcard characters, like % and _
2. Use of NOT LIKE comparison operator, for an inexact match, using wildcard character %

• Use of NOT LIKE comparison operator, for an inexact match, using wildcard character _

1. Use of at least two relational operator (>, < >=, <=, <>, !=) in the same or different statements
2. Use of all Boolean operators (AND, OR, NOT) in the same or different statements
3. Use of the BETWEEN comparison operator

• Use of a string function
• Use of a numeric function

1. Use of IN() or NOT IN() comparison function
2. Use of display/alias names
3. Displaying only some fields

• Displaying all fields of the table
• Use of order by using ASC
• Use of order by using DESC

1. Order by more than one fields

• Use of limit clause displaying some records including record 1
• Use of limit clause displaying some records in the table, not including record 1