Q1. Please write SQL codes to query data from dvd table based on below criteria Please write a SELECT statement to display different DVD title (the same title will be displayed one and only one time)...



Q1. Please write SQL codes to query data from dvd table based on below criteria


Please write a SELECT statement to display different DVD title (the same title will be displayed one and only one time) and the first character of the DVD titles must be between
‘A’
and
‘L’.
Please display the result in
descending
order (from
‘A’
to
‘L’

order). The result should be identical to below results:


[screen-shot]


TITLE ID TITLE NAME<br>18 AIR FORCE ONE<br>19 AWAY FROM AFRICA<br>32 BACK TO GIRASIC PARK<br>12 CHICKEN RUN<br>30 CINDERALA<br>10 DANCE WITH WOLF<br>20 FRIDAY 13TH<br>17 LOVE STORY<br>29 LOVE STORY II<br>

Extracted text: TITLE ID TITLE NAME 18 AIR FORCE ONE 19 AWAY FROM AFRICA 32 BACK TO GIRASIC PARK 12 CHICKEN RUN 30 CINDERALA 10 DANCE WITH WOLF 20 FRIDAY 13TH 17 LOVE STORY 29 LOVE STORY II

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here