copilot-powered.sql

# The predictions table is called models_prediction
# The users table is called users_user
# Select all predictions where the user id is equal to the user with username 'zeke'
SELECT * FROM models_prediction WHERE user_id = (SELECT id FROM users_user WHERE username = 'zeke');

# Count all predictions where the user id is equal to the user with username 'zeke'
SELECT COUNT(*) FROM models_prediction WHERE user_id = (SELECT id FROM users_user WHERE username = 'zeke');