Sobes.tech
Junior — Senior

Display the strongest password for each user

livecode

Task condition

The database contains tables users (id, name) and passwords (id, user_id, password_hash, strength_score). It is required to write an SQL query that for each user selects the password with the highest strength_score and outputs user_id, password_hash, and strength_score, ordering the result by descending strength_score.