Скачать или смотреть SQL Interview Question | Find Players Who Won Only Gold Medals

1.) Find the total number of gold medals won by each swimmer who has only won gold medals and no silver or bronze.

CREATE TABLE events (
ID INT,
event VARCHAR(255),
YEAR INT,
GOLD VARCHAR(255),
SILVER VARCHAR(255),
BRONZE VARCHAR(255));

INSERT INTO events VALUES (1,'100m',2025,'Kipchoge Ngeno','Tunde Adebayo','Amina Hassan');
INSERT INTO events VALUES (2,'200m',2025,'Zanele Moyo','Kwame Mensah','Fatou Diallo');
INSERT INTO events VALUES (3,'500m',2025,'Samuel Okeke','Zanele Moyo','Noura Benali');
INSERT INTO events VALUES (4,'100m',2025,'Brian Otieno','Lerato Nkosi','Paula Muthoni');
INSERT INTO events VALUES (5,'200m',2025,'Abdul Kamau','Carol Atieno','Steven Mutiso');
INSERT INTO events VALUES (6,'500m',2025,'Zanele Moyo','Abdul Kamau','Brian Odhiambo');
INSERT INTO events VALUES (7,'100m',2025,'Samuel Okeke','Dennis Mwangi','Noura Benali');
INSERT INTO events VALUES (8,'200m',2025,'Thomas Kibet','Dawn Wanjiru','Catherine Njeri');
INSERT INTO events VALUES (9,'500m',2025,'Thomas Kibet','Dennis Mwangi','Paula Muthoni');
INSERT INTO events VALUES (10,'100m',2025,'Samuel Okeke','Dennis Mwangi','Noura Benali');
INSERT INTO events VALUES (11,'200m',2025,'Jessica Mbatha','Donald Ochieng','Stefany Achieng');
INSERT INTO events VALUES (12,'500m',2025,'Thomas Kibet','Steven Mutiso','Catherine Njeri');




Want to ace SQL interviews and master real-world SQL skills?
Start mastering SQL today:
Enroll Here
https://paystack.shop/pay/Real-world-...


Connect with me:
LinkedIn: / erickmwangome
Email: [email protected]
Instagram: @erick_mwangome
Facebook: @Eric Lamar