Week$-3-$Performance$-$Assessment:$-$SQI$-$Features$$

The$-$following questions$-$come$-$from$-$the$-$"Check$-$your$-$understanding"$-$examples$-$of$-$each$-$section$-$of$-$

After$-$you$-$are$-$finished,$-$please$-$submit$-$a$-$Microsoft$-$Word$-$file$-$that$-$contains$-$screenshots$-$of$-$the$-$SQL$-$queriesshould$-$be$-$named ${?}^0$ W$\_3\_$PA$\_$SQLFeatures$\_$Lastname.docx. II $$

$(7-2)-$Question$-1$:$$

Modify$-$the$-$select$-$statement$-$in$-$this$-$section$-$to$-$display$-$the$-$hire date$-$column$-$in$-$the$-$format:January $10,*2012\mathrm{.}9$

$1$ insect into secoro$3$ lunches

values $,$

to date $("$O$1-10-201210$:$69$ AM$\text{'},\text{'}$MH$-$DD$-$YMY HAMI AM$\text{'}),$

$292,$ sysdate$)$;

MMRONI TAYLOR

Results

Explain

Dencribe

Saved sot

History

$1$ rosis inserted.

$0\mathrm{.}00$ seconds

$(7-3)*$Question$*2$:$9$

Add$-$a$-$new$-$row$-$to$-$a$-$copy$-$of$-$the$-$employees$-$table,sec$0703\_$employees.Set$-$the$-$hire$-$date$-$to$-$show$-$

$$

$(7-6)*$Question$*3$:$$

$$

$(7-7)*$Question$*4$:$1$

Determine$-$the$-$current$-$value$-$of$-$the$-$sequence$-$seq$\_$seco$707.$Then$-$use$-$its$-$next$-$three$-$values$-$to$-$addnew$-$rows$-$to$-$the$-$seco$707\_$sequence$-$table.This$-$table$-$has$-$only$-$one$-$column.$\text{'}$It$-$holds$-$the$-$value$-$ofthe$-$sequence$-$number, $1$