Works like a charm.
One last thing... I have the Books table and the column price and boolean column IsForFinalExams
and I need to make a query that will decrease 20% of the book Price if IsForFinalExams = True otherwise decreases 10% , any idea?
Thanks.
Thanks, works great, although I got another solution with SELECT DISTINCT subject
FROM subjects
WHERE subject_code Not In ( SELECT subject_code FROM books );
Yours is alot more efficient.
I got another question - In the Books table there is a price column, I need to check out the average (I...
I have two tables - books and subjects, they are connected using subject_code, and I need to check which subject does not have any book, how can I do that, can anyone help ?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.