COMP1201 Design Project

1.Code a select statement to display ALL data from any one of your tables, sorted by something other than primary key column 3 2.Code a select statement to display 3 columns from one of your tables with values above or below a numeric test of your choice. E.g. all rows with a price less than $10. 4 3.Code a select statement to display at least 3 columns from one table with values between two dates. Sort from most recent to oldest date. 5 4.Display several columns from one table that includes a calculated field. Include a heading (alias) for the new calculated column. Sort results from highest to lowest on your calculated column. 6 5.Display 2 columns from the primary table and 3 from its related table. Sort by one of the columns in the primary table, then within that sort, sort one of the fields in the related table. 7 6.Code an update statement to change any column’s field value to a different value. For example, change ‘Kingston’ to ‘Kings Town’. Simply make up the data. 3 7. Create a stored procedure that willaccept an input parameter. Your stored procedure will be a SELECT statement that will use the INPUT parameter as the value for theWHERE claus