Programming Questions? Ask a Programmer for Answers ASAP
is there a specific question?
sorry, i don't know oracle.
I will open your question to others.
Hi Sir, I would like to assist you.
1) Select MovieTitle from tblMovie where director in ('George Lucas','Rich Christiano')
2) Select customers from tblCustomers where status = 'Active' and plan = 'Planname'
Hi I have given answers to your first two questions. Since i do no have you database table names and schema,column inforamtion, It will be difficult to provide what you are expecting. Please provide database details to me so that you will be getting everything you want. I am sending you a phone request so that we can talk later and discuss it.
Lets have a call. You can share your screen when i tell to do so.
You can share your database relationship diagram which will helps in creating query easier and accurate way.
You sent me one JPG file. What does it consist of?
I am not able to open it right now. Once i open it, I will start working on it and get back to you shortly.
yes. Get back you after short time.
4) A customer requests the titles of all the DVD’s that he or she has not rented. Write a single query that retrieves this information for a customer of your choosing.
--> select Cusotmer.first_name, Customer.last_name, Title.title_name from Title left outer join Rental on title_id = title_id inner join customer on customer_id =customer_id
where Title.title_id not in(select title_id from Renatal)