Sure, here are the SQL queries for your questions:

1. List roll number and name of all students of the branch ‘CSE’.
```sql
SELECT Roll_No, Name
FROM Student
WHERE Branch = 'CSE';
```

2. Find the name of student who has issued a book published by ‘ABC’ publisher.
```sql
SELECT s.Name
FROM Student s
JOIN Issue i ON s.Roll_No = i.Roll_No
JOIN Book b ON i.ISBN = b.ISBN
WHERE b.Publisher = 'ABC';
```

3. List title of all books and their authors issued to a student ‘RAM’.
```sql
SELECT b.Title, b.Author
FROM Book b
JOIN Issue i ON b.ISBN = i.ISBN
JOIN Student s ON i.Roll_No = s.Roll_No
WHERE s.Name = 'RAM';
```

4. List title of all books issued on or before December 1, 2020.
```sql
SELECT b.Title
FROM Book b
JOIN Issue i ON b.ISBN = i.ISBN
WHERE i.Date-of-Issue

Question

Sure, here are the SQL queries for your questions:

1. List roll number and name of all students of the branch ‘CSE’.
```sql
SELECT Roll_No, Name 
FROM Student 
WHERE Branch = 'CSE';
```

2. Find the name of student who has issued a book published by ‘ABC’ publisher.
```sql
SELECT s.Name 
FROM Student s 
JOIN Issue i ON s.Roll_No = i.Roll_No 
JOIN Book b ON i.ISBN = b.ISBN 
WHERE b.Publisher = 'ABC';
```

3. List title of all books and their authors issued to a student ‘RAM’.
```sql
SELECT b.Title, b.Author 
FROM Book b 
JOIN Issue i ON b.ISBN = i.ISBN 
JOIN Student s ON i.Roll_No = s.Roll_No 
WHERE s.Name = 'RAM';
```

4. List title of all books issued on or before December 1, 2020.
```sql
SELECT b.Title 
FROM Book b 
JOIN Issue i ON b.ISBN = i.ISBN 
WHERE i.Date-of-Issue <= '2020-12-01';
```

5. List all books published by publisher ‘ABC’.
```sql
SELECT * 
FROM Book 
WHERE Publisher = 'ABC';
```

Please note that the date format in the fourth query might need to be adjusted depending on the SQL dialect and the format of the `Date-of-Issue` column in your database.

Knowee AI · Accepted Answer

Sure, here are the SQL queries for your questions:

1. List roll number and name of all students of the branch ‘CSE’.
```sql
SELECT Roll_No, Name 
FROM Student 
WHERE Branch = 'CSE';
```

2. Find the name of student who has issued a book published by ‘ABC’ publisher.
```sql
SELECT s.Name 
FROM Student s 
JOIN Issue i ON s.Roll_No = i.Roll_No 
JOIN Book b ON i.ISBN = b.ISBN 
WHERE b.Publisher = 'ABC';
```

3. List title of all books and their authors issued to a student ‘RAM’.
```sql
SELECT b.Title, b.Author 
FROM Book b 
JOIN Issue i ON b.ISBN = i.ISBN 
JOIN Student s ON i.Roll_No = s.Roll_No 
WHERE s.Name = 'RAM';
```

4. List title of all books issued on or before December 1, 2020.
```sql
SELECT b.Title 
FROM Book b 
JOIN Issue i ON b.ISBN = i.ISBN 
WHERE i.Date-of-Issue <= '2020-12-01';
```

5. List all books published by publisher ‘ABC’.
```sql
SELECT * 
FROM Book 
WHERE Publisher = 'ABC';
```

Please note that the date format in the fourth query might need to be adjusted depending on the SQL dialect and the format of the `Date-of-Issue` column in your database.

Question

Solution

Similar Questions

Upgrade your grade with Knowee