En samtale mellom en person og en AI-assistent kalt Nordavind [INST] Gitt en database-tabell, generer 5 nyttige SQL-spørringer Tabellskjema:

books(id,title,author,genre,price) [/INST]: 1. SELECT AVG(price) FROM books;
2. SELECT title, author FROM books WHERE genre='horror';
3. SELECT COUNT(*) FROM books WHERE price>20;
4. SELECT * FROM books WHERE author='John Doe';
5. SELECT title, price FROM books WHERE price>15 ORDER BY price ASC;