IS320 – Advanced Business Applications Spring 2021 SQL practice Feline Novelties database design 1

Subject:Computer SciencePrice:12.89 Bought3

Share With

IS320 – Advanced Business Applications Spring 2021 SQL practice Feline Novelties database design 1. Enter SQL for Query 1, use QBE below for necessary Fields, Table and criteria to complete the statement 2. Enter SQL for Query 2, use QBE below for necessary Fields, Table and Sort to complete the statement Need to use ORDER BY 3. Enter SQL for Query 5, use QBE below for necessary Fields, Tables, criteria and sort to complete the statement Create Query Design Close “Show Table” Window Select SQL view Type SQL statements For WHERE, use the following syntax Short Text datatype WHERE ( (fieldname) = “M”) Date/Time datatype WHERE ((fieldname) = #1/1/2018#) Number datatype WHERE ((field name) = 10) Sorting use ORDER BY; ORDER BY (fieldname) ; for ascending order ORDER BY (fieldname) DESC; for descending order Hands-on Activity 1. Look over SQL start doc here 2. Download "Feline Novelties" database here, and using the “Apr 14 sql" document here, type SQL for each of the 3 queries. 3. Run each SQL statement, fix syntax if necessary, check output for correctness