Assignment title: Information


Q Question a • Correct syntax • Correct use of sorting statement Question b • Correct syntax • Where statement correctly formulated Question c • Correct syntax • Where statement correctly formulated • Correct indication of desired values Question d • Correct syntax • Correct table used • Where statement correctly formulated • Correct indication of desired values Question e • Correct syntax • Correct tables used • Where statement correctly formulated • Correct sorting statement used. Question f • Correct syntax • Correct tables used • Correct use of aggregation statement • Sub-query formulated correctly • Correct answer given Question g • Correct syntax • Correct table used • Correct result for deletion Question h • Correct syntax • Correct table used • Correct result for update Question i • Correct syntax • Correct tables used • Where statement correctly formulated • Output formatted correctly Question j • Correct syntax • Correct tables used • Inserts done in correct order with correct results Q k • Correct syntax • Correct tables used • Correct calculation of sales price • Where statement correctly formatted Q l • Correct syntax • Correct tables used • Output formatted correctly