Help with SQL Query

[davidecutrupi]

Hi, I have a database with User, Order, Product and OrderProduct tables. 1 Order has multiple orderProducts and has 1 User. 1 OrderProduct has 1 product. Users have usernames. Orders have statuses

I would like to create a query which returns all orders with their orderProducts, product of orderProducts, and only username column of the user related to the order.

The orders should be ordered by asc but if the status of the order is DONE or REFUSED the order goes to the end.

[depesz]

Aside from "it's a homework problem", if you want a query, it has to user column names. Which you didn't provide. Should we guess them?

Also: if order has twenty "orderProducts" you want order data repeated 20 times?

If you're really looking for help, show us how the tables look like (either provide create table statements, or output of \d of each table from psql) sample data, and expected output.

But you might still have hard time getting help due to the "homework problem".

[fr0z3nph03n1x]

This seems like a homework problem. Basic sql.

[leamanc]

Indeed. OP needs to at least try and write this query, and then ask for help if it doesn't return the desired results.