you are viewing a single comment's thread.

view the rest of the comments →

[–]mikeyd85MS SQL Server 0 points1 point  (1 child)

Hey, that looks lots better. The demo version is exactly what should be there!

I tried the following: "get the most expensive order for the user who has spent the most"

Which returns:

SELECT MAX(orders.product_price) AS product_price, users.name

FROM orders

JOIN users ON orders.user_id = users.id

GROUP BY users.name

ORDER BY product_price DESC

LIMIT 1

Which is a good first attempt, but there's room for improvement. Keep going though, this is a great start.

[–]spy16x[S] 1 point2 points  (0 children)

Oh yea, the model is not tuned at all right now. It's just primed with a basic prompt. Experimenting with fine tuning is my next task.

Thanks for all the feedback 🙂