A university wants to know all course names of sections that student Cam Sato has enrolled in. Instructor •InstructorID Section Instructor • SectionID Section ⚫SectionID Enrollment ⚫ SectionID Student ⚫ StudentID FirstName • InstructorID LastName AcademicRank CourseID Term StudentID Capacity Salary Course •CourseID FirstName LastName EmailAddress BirthDate Name Description The query below answers the university's question. Fill in the blanks. SELECT DISTINCT C.Name FROM ___ (A)___ (B) Section SE ON C.CourseID =SE.CourseID INNER JOIN Enrollment E ON SE.SectionID = E. SectionID INNER JOIN Student ST ON E.StudentID = _ (C)_____ WHERE ST. FirstName = 'Cam' AND ST. LastName = 'Sato'; Credits (A) Ex: Keyword 1 @O

DO NOT COPY FROM OTHER WEBSITES Correct and detailed answer will be Upvoted else downvoted. Also explain why other options are FALSE. Thank you!

Task 2: ' The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.

How many times has each language been used in films? Return the value for all six languages. Display: language name and the number of films

1.What is the result when the following SQL query is executed on a table named products? Choose the most correct answer. SELECT AVG(Products)FROM Products; Group of answer choices The query results in an error because the is no AVG function None of the above The query results in an error be cause a column is not specified The query returns the average of the Products table   2. If the primary key in the Employee table is located in the "ID" column what is the maximum number of results the following SQL SELECT query will return? SELECT *FROM EmployeeWHERE ID = 15; Group of answer choices 2 1 3 Do not have enough information to determine the answer 0

Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.

The database should contain the following six tables: Artists (artist_id: char(30), artist_name: char(30), artist_pop: int(5))Tracks (track_id: char(30), track_name: char(30), duration: int(10), tempo:real) Record (artist_id: char(30), track_id: char(30))Users (user_id: char(30), user_name: char(30), age: int(5), nationality: char(30), num_track_listened: int(10))Listen (user_id: char(30), track_id: char(30))Follow (user_id: char(30), artist_id: char(30), follow_date: datetime) Write a single SQL query for each request below. Find the ids of those users who have listened to at least one track but have not followed any artists. Find the ids and names of those users who have listened to some tracks recorded by the artist named 'Adele'. Find the ids and names of those users who have not listened to any track recorded by the artist named 'Adele'. Use ''NOT EXISTS'' to answer this query.

Write SQL statements to create at the two tables for the database. The tables must have at least three relevant columns with appropriate types, a primary key and at least one table should have a foreign key and the related foreign key constraints. CREATE TABLE students ( Student_id int NOT NULL PRIMARY KEY, Stud_firstname VARCHAR(30) NOT NULL, Stud_lastname VARCHAR(30) NOT NULL, Stud_email VARCHAR(80) NOT NULL UNIQUE advisor_id int, );   create table advisor ( advisor_id int not null primary key, stud_id int, adv_firstname varchar(30), adv_lastname varchar(30), foreign key(student_id) references students(student_id) );   [keep getting error, need help correcting]

Using the Henry Books database,Henry Books no longer carries books written by Barbara Owen. Delete this author from the authors table.  You will insert 2 snips for this question. What construct did you use to delete author Barbara Owens? Insert the snip of the construct used:     Insert the snip of the authors table.  Be sure all rows are displayed:

Please convert this EERD to relation. Thanks