Computer Science – 8.3 Data Definition Language (DDL) and Data Manipulation Language (DML) | e-Consult
8.3 Data Definition Language (DDL) and Data Manipulation Language (DML) (1 questions)
Login to see all questions.
Click on a question to view the answer
`sql
SELECT
m.Name,
b.Title
FROM
Members m
JOIN
Books b ON m.MemberID = b.BookID
WHERE
b.PublicationYear > 2000;
`
Explanation:
- The query joins the Members and Books tables using the MemberID and BookID columns, respectively.
- The WHERE clause filters the results to include only books published after the year 2000.
- The SELECT statement retrieves the Name from the Members table and the Title from the Books table.