SELECT DISTINCT storeName, userId FROM orders; storeName userId Store A 43 Store B 57 Store C 82 Store A 21 Read SQL Group By vs Distinct online: https://riptutorial.com/sql/topic/2499/sql-group-by-vs- distinct https://riptutorial.com/ 164