How to I Translate the following statements below to SQL language?

Question

1- Show the list of videoNo which are returned from table rentalagreement
2- Display everything about those videos which have the key word “Never” in their titles

Answer 1

Something like this.......

1. select videoNo from rentalagreement;

2. select * from rentalagreement where title like '%Never%';

Answer 2

Let me see your query so I can test it and suggest you something ...

Answer 3

Ipang
This is my Assignment
And I'm beginner in sql

Answer 4

Rahima Mirzad
Would you mind if I suggest you to get in the SQL tutorial first? I believe you will find answers to your task requirements as you make your way through the tutorial 👍

Answer 5

Rahima Mirzad

https://www.w3schools.com/sql/sql_like.asp

Answer 6

Quantum
What is "like" in your answer 🤔