Explore Westonci.ca, the premier Q&A site that helps you find precise answers to your questions, no matter the topic. Discover a wealth of knowledge from experts across different disciplines on our comprehensive Q&A platform. Get quick and reliable solutions to your questions from a community of experienced experts on our platform.


4. Return the card number, first name, last name, and average late fee of each customer. Name this column as "Fee".
5. Return the authors whose first names are shorter than all last names.
6. Return the first 10 borrowing which late fee is unknown.

How do I write these using Oracle SQL sub selects?