Posts by Jota • 1 point
2 posts
-
0
votes1
answer33
viewsQ: Left Join with Two Counts from the same table
Good people, I have a system that I made to make a pool with my friends. I want to select users and then count the right guesses and the wrong guesses. The database looks like this (I removed the…
-
0
votes1
answer44
viewsQ: How to select rows that match one of the columns in different tables?
I have two tables: one that registers the games of the round and the other that registers the guesses for these games. I want to show a table where the Game appears, the user’s guess X and if it has…