3 ms·
There are dozens of different ways you could write the given query, e.g., Select members.firstname + ' ' + members.lastname as "Full Name" From members J
by taberiand 10y ago
There are dozens of different ways you could write the given query, e.g.,
Select members.firstname + ' ' + members.lastname as "Full Name"
From members
Join borrowings on members.memberid = borrowings.memberid
Join (
Select bookid
from books
where stock > (Select avg(stock) from books)
) books on borrowings.bookid = books.bookid
Using comma syntax precludes many of these other forms, and therefore I would not recommend teaching it to beginners (or in fact ever using it), as it limits your options.