SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE users ( id serial primary key, name varchar(255) ); INSERT INTO users VALUES (1, 'John'), (2, 'Sarah'); CREATE TABLE shares ( id varchar(12) primary key, price numeric ); INSERT INTO shares VALUES ('TSLA', 781.30), ('AAPL', 105.00); CREATE TABLE user_shares ( user_id int, share varchar(12), count int ); INSERT INTO user_shares VALUES (1, 'TSLA', 5), (2, 'AAPL', 1); SELECT users.*, shares.*, user_shares.count, user_shares.count * shares.price total FROM user_shares JOIN users ON user_shares.user_id = users.id JOIN shares ON user_shares.share = shares.id ;