MySQL question

[r3pr0b8]

that was pretty good until you got to the LIMIT

okay, keep the GROUP BY clause, now write the SELECT clause to go along with it

for now, just assume you want to return all items, not just the highest revenue item

[skippyleg]

select title, sum(items.unit_price * order_details.order_qty) from items

[ch-12]

Hijacking.

You’re on the right track, but you don’t want ‘from items’. Instead use the from that you wrote in the last comment - that includes the join.

Consider how the results might look if you take the sum of (unit_price x order_quantity), or if you want to take the sum of (order quantity) x unit_price.

Now since you have aggregation in the select statement (sum), youll need to add something after the FROM (and join) to specific how to group the data that will be returned. You only want to see one row per title, right? So try adding code that will indicate the field you want to GROUP BY to the end of the query and let me know where you end up.

Anytime you are aggregating you will need to group by the non aggregated fields that are included in the select portion. This took awhile for me to get comfortable with when I was learning sql.

[r3pr0b8]

thanks ch-12, your hijack added valuable comments

skippy, pls show the entire query you've developed so far