PROMPT ***********************; PROMPT 6.5.1; /* Videos Type I Using a Type I su

Question

PROMPT ***********************;
PROMPT 6.5.1;
/* Videos
Type I

Using a Type I subquery, show which videos were watched during the
first week of February if the video is over 10 minutes in length.

Show the video's main topic, short title, and length. Sort by
main topic then title.

VIDEOS.WATCH_DATA VIDEOS.VIDEOS WATCH DATE GEOGRAPHY ID VIDEO ID WATCH TIME MINUTES VIEWS AVERAGE_VIEW_DURATION_MINUTES NUMBER (8,2) LIKES DISLIKES WATCHID VIDEO ID VIDEO TITLE VIDEO LENGTH_MINUTES NUMBER (6,2) VIDEO CREATED SHORT TITLE MAINTOPIC VARCHAR2 (36 BYTE) VARCHAR2 (200 BYTE) DATE VARCHAR2 (5 BYTE) VARCHAR2 (35 BYTE) NUMBER (B) NUMBER (5) VARCHAR2 (20 BYTE VARCHAR2 (32 BYTE) VARCHAR2 (20 BYTE) NUMBER (5) NUMBER (5) NUMBER PK VIDEOID (MDEO_ID) ? PK VIDEOID(VIDEO-ID) - PK WATCHID (WATCH ID) UNQ_GEO VIDEO WATCH_DATE (WATCH DATE, GEOGRAPHY_ID, VIDEO ID) FK GEOID (GEOGRAPHY ID) FK VIDEOID MDEO_ID) PK WATCHID (WATCH ID) UNQ-GEO-VIDEO-WATCH-DATE(WATCH-DATE. GEOGRAPHY-ID. VIDEO-ID) VIDEOS.GEOGRAPHY GEOGRAPHY ID VARCHAR2 (5 BYTE) GEOGRAPHY REGION VARCHAR2 (80 BYTE) VARCHAR2 (25 BYTE) PK_GEOID (GEOGRAPHY_ID) FK GEO_REGION (REGION) PK GEOID (GEOGRAPHY_ID) VIDEOS.TRAFFIC_SOURCE VIDEOS.REGION VIDEO-ID GEO ID WATCH DATE TRAFFIC SOURCE VARCHAR2 (35 BYTE) VARCHAR2 (10 BYTE) VARCHAR2 (35 BYTE) VARCHAR2 (5 BYTE) DATE REGION VARCHAR2 (30 BYTE) PK REION (REGION) PK-REION (REGION) ? TRAFFIC_SOURCE_PK(TS_ID) FKTRAFFICE VIDEO (VIDEO ID) FK TRAFFIC GEO (GEO ID) TRAFFIC_SOURCE PK(TS_ID)

Explanation / Answer

SELECT Main_TOPIC,SHORT_TITLE,VIDEO_LENGHTH_MINUITES FROM VIDEOS.VIDEOS

WHERE VIDEO_ID IN (SELECT VIDEO_ID FROM VIDEOS.WATCH_DATA

WHERE WATCH_DATE>='2018-02-01' AND '2018-02-07')

AND VIDEO_LENGHTH_MINUITES>10;

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.