SQLize | PHPize | SQLtest

CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, gender ENUM('Male', 'Female', 'Other'), date_of_birth DATE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); INSERT INTO users (name, email, gender, date_of_birth) VALUES ('Ahmed Ali', 'ahmed.ali@example.com', 'Male', '1992-05-14'), ('Fatima Khan', 'fatima.khan@example.com', 'Female', '1995-08-21'), ('Muhammad Usman', 'usman.muhammad@example.com', 'Male', '1989-12-09'), ('Ayesha Siddiqui', 'ayesha.siddiqui@example.com', 'Female', '1994-03-17'), ('Hamza Qureshi', 'hamza.qureshi@example.com', 'Male', '1990-07-02'), ('Zainab Noor', 'zainab.noor@example.com', 'Female', '1996-11-26'), ('Bilal Saeed', 'bilal.saeed@example.com', 'Male', '1993-06-05'), ('Hafsa Jameel', 'hafsa.jameel@example.com', 'Female', '1991-09-14'), ('Omar Farooq', 'omar.farooq@example.com', 'Male', '1988-04-28'), ('Maryam Raza', 'maryam.raza@example.com', 'Female', '1997-10-11'), ('Imran Tariq', 'imran.tariq@example.com', 'Male', '1990-01-18'), ('Laiba Haroon', 'laiba.haroon@example.com', 'Female', '1995-05-23'), ('Yusuf Kamal', 'yusuf.kamal@example.com', 'Male', '1987-02-03'), ('Noor Fatima', 'noor.fatima@example.com', 'Female', '1998-07-27'), ('Samiullah Zafar', 'samiullah.zafar@example.com', 'Male', '1992-03-10'), ('Hira Aslam', 'hira.aslam@example.com', 'Female', '1996-12-19'), ('Tariq Nadeem', 'tariq.nadeem@example.com', 'Male', '1989-09-01'), ('Maha Irfan', 'maha.irfan@example.com', 'Female', '1994-11-05'), ('Adnan Bashir', 'adnan.bashir@example.com', 'Male', '1991-06-15'), ('Aleena Shafi', 'aleena.shafi@example.com', 'Female', '1993-08-29'), ('Rizwan Haider', 'rizwan.haider@example.com', 'Male', '1988-10-30'), ('Amna Yousaf', 'amna.yousaf@example.com', 'Female', '1997-01-12'), ('Kashif Mehmood', 'kashif.mehmood@example.com', 'Male', '1990-03-08'), ('Sana Parveen', 'sana.parveen@example.com', 'Female', '1995-06-17'), ('Noman Arif', 'noman.arif@example.com', 'Male', '1992-04-03'), ('Iqra Shahid', 'iqra.shahid@example.com', 'Female', '1996-09-21'), ('Waqar Ahmed', 'waqar.ahmed@example.com', 'Male', '1989-12-25'), ('Zoya Khalid', 'zoya.khalid@example.com', 'Female', '1993-07-09'), ('Farhan Nazir', 'farhan.nazir@example.com', 'Male', '1991-05-30'), ('Rubina Anwar', 'rubina.anwar@example.com', 'Female', '1994-02-16'); --SELECT * FROM users; --ADDRESSES TABLE --------- CREATE TABLE addresses( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, street VARCHAR(255), city VARCHAR(150), state VARCHAR(150), pincode VARCHAR(10), CONSTRAINT fk_user FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE ); INSERT INTO addresses (user_id , street, city, state, pincode) vALUES (1, '123 Main Street', 'Lahore', 'Punjab', '54000'), (2, '45-A Model Town', 'Karachi', 'Sindh', '74000'), (3, '789 Garden Road', 'Islamabad', 'Capital Territory', '44000'), (4, '11 Shalimar Block', 'Rawalpindi', 'Punjab', '46000'), (5, '22 Canal View', 'Faisalabad', 'Punjab', '38000'), (6, 'Plot 17, Gulshan-e-Iqbal', 'Karachi', 'Sindh', '75300'), (7, 'House #34, DHA Phase 3', 'Lahore', 'Punjab', '54792'), (8, '88 Satellite Town', 'Quetta', 'Balochistan', '87300'), (9, 'House 102, Peshawar Road', 'Peshawar', 'KPK', '25000'), (10, 'Street 5, G-11', 'Islamabad', 'Capital Territory', '44000'), (11, 'Block C, North Nazimabad', 'Karachi', 'Sindh', '74700'), (12, 'House 77, Iqbal Town', 'Multan', 'Punjab', '60000'), (13, '96 Civic Centre', 'Sialkot', 'Punjab', '51040'), (14, 'Flat 2B, Gulberg Greens', 'Lahore', 'Punjab', '54660'), (15, 'Plot 34, Phase 6', 'Karachi', 'Sindh', '75100'), (16, '15 Jinnah Avenue', 'Bahawalpur', 'Punjab', '63100'), (17, 'Block 7, Gulshan-e-Maymar', 'Karachi', 'Sindh', '75340'), (18, 'Street 4, H-8', 'Islamabad', 'Capital Territory', '44090'), (19, 'Plot 10, Charsadda Road', 'Peshawar', 'KPK', '25050'), (20, 'House #11, Blue Area', 'Islamabad', 'Capital Territory', '44000'), (21, '33 Ravi Road', 'Lahore', 'Punjab', '54010'), (22, 'Block A, Satellite Town', 'Rawalpindi', 'Punjab', '46010'), (23, 'Street 11, Gulistan-e-Johar', 'Karachi', 'Sindh', '75290'), (24, 'House 88, Officers Colony', 'Faisalabad', 'Punjab', '38010'), (25, 'Flat 302, Mall Road', 'Murree', 'Punjab', '47150'), (26, '34 Fort Road', 'Hyderabad', 'Sindh', '71000'), (27, '22-A Hali Road', 'Sargodha', 'Punjab', '40100'), (28, 'Block E, University Town', 'Peshawar', 'KPK', '25120'), (29, 'House 45, G-9/1', 'Islamabad', 'Capital Territory', '44010'), (30, 'Street 10, Tariq Road', 'Karachi', 'Sindh', '75400'); --SELECT users.name, addresses.city,addresses.pincode --FROM users --LEFT JOIN addresses ON users.id = addresses.user_id; --SELECT * FROM addresses WHERE city = 'Quetta'; --SELECT * FROM users; --UPDATE users --SET name = 'danish' --where id = 1; ALTER TABLE users ADD COLUMN salary int NOT NULL; UPDATE users SET salary = 55000 WHERE id = 1; UPDATE users SET salary = 72000 WHERE id = 2; UPDATE users SET salary = 45000 WHERE id = 3; UPDATE users SET salary = 61000 WHERE id = 4; UPDATE users SET salary = 39000 WHERE id = 5; UPDATE users SET salary = 80000 WHERE id = 6; UPDATE users SET salary = 34000 WHERE id = 7; UPDATE users SET salary = 69000 WHERE id = 8; UPDATE users SET salary = 57000 WHERE id = 9; UPDATE users SET salary = 43000 WHERE id = 10; UPDATE users SET salary = 76000 WHERE id = 11; UPDATE users SET salary = 64000 WHERE id = 12; UPDATE users SET salary = 49000 WHERE id = 13; UPDATE users SET salary = 52000 WHERE id = 14; UPDATE users SET salary = 78000 WHERE id = 15; UPDATE users SET salary = 35000 WHERE id = 16; UPDATE users SET salary = 74000 WHERE id = 17; UPDATE users SET salary = 67000 WHERE id = 18; UPDATE users SET salary = 41000 WHERE id = 19; UPDATE users SET salary = 59000 WHERE id = 20; UPDATE users SET salary = 38000 WHERE id = 21; UPDATE users SET salary = 70000 WHERE id = 22; UPDATE users SET salary = 56000 WHERE id = 23; UPDATE users SET salary = 36000 WHERE id = 24; UPDATE users SET salary = 75000 WHERE id = 25; UPDATE users SET salary = 33000 WHERE id = 26; UPDATE users SET salary = 62000 WHERE id = 27; UPDATE users SET salary = 40000 WHERE id = 28; UPDATE users SET salary = 68000 WHERE id = 29; UPDATE users SET salary = 53000 WHERE id = 30; UPDATE users SET gender = 'other' WHERE id = 25; --SELECT * FROM users WHERE gender = 'other'; --DELETE From users --WHERE gender = 'other'; SELECT COUNT(*) FROM users WHERE gender = 'Female'; SELECT MIN(salary) AS min_salary , MAX(salary) AS max_salary FROM users; SELECT SUM(salary) AS total_payroll FROM users; SELECT AVG(salary) AS avg_salary FROM users; SELECT gender, AVG(salary) AS avg_salary from users GROUP BY gender; SELECT * FROM users WHERE gender = 'other'; DELETE FROM users WHERE id = 25; CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, gender ENUM('Male', 'Female', 'Other'), date_of_birth DATE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); INSERT INTO users (name, email, gender, date_of_birth) VALUES ('Ahmed Ali', 'ahmed.ali@example.com', 'Male', '1992-05-14'), ('Fatima Khan', 'fatima.khan@example.com', 'Female', '1995-08-21'), ('Muhammad Usman', 'usman.muhammad@example.com', 'Male', '1989-12-09'), ('Ayesha Siddiqui', 'ayesha.siddiqui@example.com', 'Female', '1994-03-17'), ('Hamza Qureshi', 'hamza.qureshi@example.com', 'Male', '1990-07-02'), ('Zainab Noor', 'zainab.noor@example.com', 'Female', '1996-11-26'), ('Bilal Saeed', 'bilal.saeed@example.com', 'Male', '1993-06-05'), ('Hafsa Jameel', 'hafsa.jameel@example.com', 'Female', '1991-09-14'), ('Omar Farooq', 'omar.farooq@example.com', 'Male', '1988-04-28'), ('Maryam Raza', 'maryam.raza@example.com', 'Female', '1997-10-11'), ('Imran Tariq', 'imran.tariq@example.com', 'Male', '1990-01-18'), ('Laiba Haroon', 'laiba.haroon@example.com', 'Female', '1995-05-23'), ('Yusuf Kamal', 'yusuf.kamal@example.com', 'Male', '1987-02-03'), ('Noor Fatima', 'noor.fatima@example.com', 'Female', '1998-07-27'), ('Samiullah Zafar', 'samiullah.zafar@example.com', 'Male', '1992-03-10'), ('Hira Aslam', 'hira.aslam@example.com', 'Female', '1996-12-19'), ('Tariq Nadeem', 'tariq.nadeem@example.com', 'Male', '1989-09-01'), ('Maha Irfan', 'maha.irfan@example.com', 'Female', '1994-11-05'), ('Adnan Bashir', 'adnan.bashir@example.com', 'Male', '1991-06-15'), ('Aleena Shafi', 'aleena.shafi@example.com', 'Female', '1993-08-29'), ('Rizwan Haider', 'rizwan.haider@example.com', 'Male', '1988-10-30'), ('Amna Yousaf', 'amna.yousaf@example.com', 'Female', '1997-01-12'), ('Kashif Mehmood', 'kashif.mehmood@example.com', 'Male', '1990-03-08'), ('Sana Parveen', 'sana.parveen@example.com', 'Female', '1995-06-17'), ('Noman Arif', 'noman.arif@example.com', 'Male', '1992-04-03'), ('Iqra Shahid', 'iqra.shahid@example.com', 'Female', '1996-09-21'), ('Waqar Ahmed', 'waqar.ahmed@example.com', 'Male', '1989-12-25'), ('Zoya Khalid', 'zoya.khalid@example.com', 'Female', '1993-07-09'), ('Farhan Nazir', 'farhan.nazir@example.com', 'Male', '1991-05-30'), ('Rubina Anwar', 'rubina.anwar@example.com', 'Female', '1994-02-16'); --SELECT * FROM users; --ADDRESSES TABLE --------- CREATE TABLE addresses( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, street VARCHAR(255), city VARCHAR(150), state VARCHAR(150), pincode VARCHAR(10), CONSTRAINT fk_user FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE ); INSERT INTO addresses (user_id , street, city, state, pincode) vALUES (1, '123 Main Street', 'Lahore', 'Punjab', '54000'), (2, '45-A Model Town', 'Karachi', 'Sindh', '74000'), (3, '789 Garden Road', 'Islamabad', 'Capital Territory', '44000'), (4, '11 Shalimar Block', 'Rawalpindi', 'Punjab', '46000'), (5, '22 Canal View', 'Faisalabad', 'Punjab', '38000'), (6, 'Plot 17, Gulshan-e-Iqbal', 'Karachi', 'Sindh', '75300'), (7, 'House #34, DHA Phase 3', 'Lahore', 'Punjab', '54792'), (8, '88 Satellite Town', 'Quetta', 'Balochistan', '87300'), (9, 'House 102, Peshawar Road', 'Peshawar', 'KPK', '25000'), (10, 'Street 5, G-11', 'Islamabad', 'Capital Territory', '44000'), (11, 'Block C, North Nazimabad', 'Karachi', 'Sindh', '74700'), (12, 'House 77, Iqbal Town', 'Multan', 'Punjab', '60000'), (13, '96 Civic Centre', 'Sialkot', 'Punjab', '51040'), (14, 'Flat 2B, Gulberg Greens', 'Lahore', 'Punjab', '54660'), (15, 'Plot 34, Phase 6', 'Karachi', 'Sindh', '75100'), (16, '15 Jinnah Avenue', 'Bahawalpur', 'Punjab', '63100'), (17, 'Block 7, Gulshan-e-Maymar', 'Karachi', 'Sindh', '75340'), (18, 'Street 4, H-8', 'Islamabad', 'Capital Territory', '44090'), (19, 'Plot 10, Charsadda Road', 'Peshawar', 'KPK', '25050'), (20, 'House #11, Blue Area', 'Islamabad', 'Capital Territory', '44000'), (21, '33 Ravi Road', 'Lahore', 'Punjab', '54010'), (22, 'Block A, Satellite Town', 'Rawalpindi', 'Punjab', '46010'), (23, 'Street 11, Gulistan-e-Johar', 'Karachi', 'Sindh', '75290'), (24, 'House 88, Officers Colony', 'Faisalabad', 'Punjab', '38010'), (25, 'Flat 302, Mall Road', 'Murree', 'Punjab', '47150'), (26, '34 Fort Road', 'Hyderabad', 'Sindh', '71000'), (27, '22-A Hali Road', 'Sargodha', 'Punjab', '40100'), (28, 'Block E, University Town', 'Peshawar', 'KPK', '25120'), (29, 'House 45, G-9/1', 'Islamabad', 'Capital Territory', '44010'), (30, 'Street 10, Tariq Road', 'Karachi', 'Sindh', '75400'); --SELECT users.name, addresses.city,addresses.pincode --FROM users --LEFT JOIN addresses ON users.id = addresses.user_id; --SELECT * FROM addresses WHERE city = 'Quetta'; --SELECT * FROM users; --UPDATE users --SET name = 'danish' --where id = 1; ALTER TABLE users ADD COLUMN salary int NOT NULL; UPDATE users SET salary = 55000 WHERE id = 1; UPDATE users SET salary = 72000 WHERE id = 2; UPDATE users SET salary = 45000 WHERE id = 3; UPDATE users SET salary = 61000 WHERE id = 4; UPDATE users SET salary = 39000 WHERE id = 5; UPDATE users SET salary = 80000 WHERE id = 6; UPDATE users SET salary = 34000 WHERE id = 7; UPDATE users SET salary = 69000 WHERE id = 8; UPDATE users SET salary = 57000 WHERE id = 9; UPDATE users SET salary = 43000 WHERE id = 10; UPDATE users SET salary = 76000 WHERE id = 11; UPDATE users SET salary = 64000 WHERE id = 12; UPDATE users SET salary = 49000 WHERE id = 13; UPDATE users SET salary = 52000 WHERE id = 14; UPDATE users SET salary = 78000 WHERE id = 15; UPDATE users SET salary = 35000 WHERE id = 16; UPDATE users SET salary = 74000 WHERE id = 17; UPDATE users SET salary = 67000 WHERE id = 18; UPDATE users SET salary = 41000 WHERE id = 19; UPDATE users SET salary = 59000 WHERE id = 20; UPDATE users SET salary = 38000 WHERE id = 21; UPDATE users SET salary = 70000 WHERE id = 22; UPDATE users SET salary = 56000 WHERE id = 23; UPDATE users SET salary = 36000 WHERE id = 24; UPDATE users SET salary = 75000 WHERE id = 25; UPDATE users SET salary = 33000 WHERE id = 26; UPDATE users SET salary = 62000 WHERE id = 27; UPDATE users SET salary = 40000 WHERE id = 28; UPDATE users SET salary = 68000 WHERE id = 29; UPDATE users SET salary = 53000 WHERE id = 30; UPDATE users SET gender = 'other' WHERE id = 25; --SELECT * FROM users WHERE gender = 'other'; DELETE From users WHERE gender = 'other'; --SELECT * FROM users; CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) NOT NULL, email VARCHAR(100) UNIQUE NOT NULL, gender ENUM('Male', 'Female', 'Other'), date_of_birth DATE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); INSERT INTO users (name, email, gender, date_of_birth) VALUES ('Ahmed Ali', 'ahmed.ali@example.com', 'Male', '1992-05-14'), ('Fatima Khan', 'fatima.khan@example.com', 'Female', '1995-08-21'), ('Muhammad Usman', 'usman.muhammad@example.com', 'Male', '1989-12-09'), ('Ayesha Siddiqui', 'ayesha.siddiqui@example.com', 'Female', '1994-03-17'), ('Hamza Qureshi', 'hamza.qureshi@example.com', 'Male', '1990-07-02'), ('Zainab Noor', 'zainab.noor@example.com', 'Female', '1996-11-26'), ('Bilal Saeed', 'bilal.saeed@example.com', 'Male', '1993-06-05'), ('Hafsa Jameel', 'hafsa.jameel@example.com', 'Female', '1991-09-14'), ('Omar Farooq', 'omar.farooq@example.com', 'Male', '1988-04-28'), ('Maryam Raza', 'maryam.raza@example.com', 'Female', '1997-10-11'), ('Imran Tariq', 'imran.tariq@example.com', 'Male', '1990-01-18'), ('Laiba Haroon', 'laiba.haroon@example.com', 'Female', '1995-05-23'), ('Yusuf Kamal', 'yusuf.kamal@example.com', 'Male', '1987-02-03'), ('Noor Fatima', 'noor.fatima@example.com', 'Female', '1998-07-27'), ('Samiullah Zafar', 'samiullah.zafar@example.com', 'Male', '1992-03-10'), ('Hira Aslam', 'hira.aslam@example.com', 'Female', '1996-12-19'), ('Tariq Nadeem', 'tariq.nadeem@example.com', 'Male', '1989-09-01'), ('Maha Irfan', 'maha.irfan@example.com', 'Female', '1994-11-05'), ('Adnan Bashir', 'adnan.bashir@example.com', 'Male', '1991-06-15'), ('Aleena Shafi', 'aleena.shafi@example.com', 'Female', '1993-08-29'), ('Rizwan Haider', 'rizwan.haider@example.com', 'Male', '1988-10-30'), ('Amna Yousaf', 'amna.yousaf@example.com', 'Female', '1997-01-12'), ('Kashif Mehmood', 'kashif.mehmood@example.com', 'Male', '1990-03-08'), ('Sana Parveen', 'sana.parveen@example.com', 'Female', '1995-06-17'), ('Noman Arif', 'noman.arif@example.com', 'Male', '1992-04-03'), ('Iqra Shahid', 'iqra.shahid@example.com', 'Female', '1996-09-21'), ('Waqar Ahmed', 'waqar.ahmed@example.com', 'Male', '1989-12-25'), ('Zoya Khalid', 'zoya.khalid@example.com', 'Female', '1993-07-09'), ('Farhan Nazir', 'farhan.nazir@example.com', 'Male', '1991-05-30'), ('Rubina Anwar', 'rubina.anwar@example.com', 'Female', '1994-02-16'); --SELECT * FROM users; --ADDRESSES TABLE --------- CREATE TABLE addresses( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, street VARCHAR(255), city VARCHAR(150), state VARCHAR(150), pincode VARCHAR(10), CONSTRAINT fk_user FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE ); INSERT INTO addresses (user_id , street, city, state, pincode) vALUES (1, '123 Main Street', 'Lahore', 'Punjab', '54000'), (2, '45-A Model Town', 'Karachi', 'Sindh', '74000'), (3, '789 Garden Road', 'Islamabad', 'Capital Territory', '44000'), (4, '11 Shalimar Block', 'Rawalpindi', 'Punjab', '46000'), (5, '22 Canal View', 'Faisalabad', 'Punjab', '38000'), (6, 'Plot 17, Gulshan-e-Iqbal', 'Karachi', 'Sindh', '75300'), (7, 'House #34, DHA Phase 3', 'Lahore', 'Punjab', '54792'), (8, '88 Satellite Town', 'Quetta', 'Balochistan', '87300'), (9, 'House 102, Peshawar Road', 'Peshawar', 'KPK', '25000'), (10, 'Street 5, G-11', 'Islamabad', 'Capital Territory', '44000'), (11, 'Block C, North Nazimabad', 'Karachi', 'Sindh', '74700'), (12, 'House 77, Iqbal Town', 'Multan', 'Punjab', '60000'), (13, '96 Civic Centre', 'Sialkot', 'Punjab', '51040'), (14, 'Flat 2B, Gulberg Greens', 'Lahore', 'Punjab', '54660'), (15, 'Plot 34, Phase 6', 'Karachi', 'Sindh', '75100'), (16, '15 Jinnah Avenue', 'Bahawalpur', 'Punjab', '63100'), (17, 'Block 7, Gulshan-e-Maymar', 'Karachi', 'Sindh', '75340'), (18, 'Street 4, H-8', 'Islamabad', 'Capital Territory', '44090'), (19, 'Plot 10, Charsadda Road', 'Peshawar', 'KPK', '25050'), (20, 'House #11, Blue Area', 'Islamabad', 'Capital Territory', '44000'), (21, '33 Ravi Road', 'Lahore', 'Punjab', '54010'), (22, 'Block A, Satellite Town', 'Rawalpindi', 'Punjab', '46010'), (23, 'Street 11, Gulistan-e-Johar', 'Karachi', 'Sindh', '75290'), (24, 'House 88, Officers Colony', 'Faisalabad', 'Punjab', '38010'), (25, 'Flat 302, Mall Road', 'Murree', 'Punjab', '47150'), (26, '34 Fort Road', 'Hyderabad', 'Sindh', '71000'), (27, '22-A Hali Road', 'Sargodha', 'Punjab', '40100'), (28, 'Block E, University Town', 'Peshawar', 'KPK', '25120'), (29, 'House 45, G-9/1', 'Islamabad', 'Capital Territory', '44010'), (30, 'Street 10, Tariq Road', 'Karachi', 'Sindh', '75400'); --SELECT users.name, addresses.city,addresses.pincode --FROM users --LEFT JOIN addresses ON users.id = addresses.user_id; --SELECT * FROM addresses WHERE city = 'Quetta'; --SELECT * FROM users; --UPDATE users --SET name = 'danish' --where id = 1; ALTER TABLE users ADD COLUMN salary int NOT NULL; UPDATE users SET salary = 55000 WHERE id = 1; UPDATE users SET salary = 72000 WHERE id = 2; UPDATE users SET salary = 45000 WHERE id = 3; UPDATE users SET salary = 61000 WHERE id = 4; UPDATE users SET salary = 39000 WHERE id = 5; UPDATE users SET salary = 80000 WHERE id = 6; UPDATE users SET salary = 34000 WHERE id = 7; UPDATE users SET salary = 69000 WHERE id = 8; UPDATE users SET salary = 57000 WHERE id = 9; UPDATE users SET salary = 43000 WHERE id = 10; UPDATE users SET salary = 76000 WHERE id = 11; UPDATE users SET salary = 64000 WHERE id = 12; UPDATE users SET salary = 49000 WHERE id = 13; UPDATE users SET salary = 52000 WHERE id = 14; UPDATE users SET salary = 78000 WHERE id = 15; UPDATE users SET salary = 35000 WHERE id = 16; UPDATE users SET salary = 74000 WHERE id = 17; UPDATE users SET salary = 67000 WHERE id = 18; UPDATE users SET salary = 41000 WHERE id = 19; UPDATE users SET salary = 59000 WHERE id = 20; UPDATE users SET salary = 38000 WHERE id = 21; UPDATE users SET salary = 70000 WHERE id = 22; UPDATE users SET salary = 56000 WHERE id = 23; UPDATE users SET salary = 36000 WHERE id = 24; UPDATE users SET salary = 75000 WHERE id = 25; UPDATE users SET salary = 33000 WHERE id = 26; UPDATE users SET salary = 62000 WHERE id = 27; UPDATE users SET salary = 40000 WHERE id = 28; UPDATE users SET salary = 68000 WHERE id = 29; UPDATE users SET salary = 53000 WHERE id = 30; UPDATE users SET gender = 'other' WHERE id = 25; --SELECT * FROM users WHERE gender = 'other'; DELETE From users WHERE gender = 'other'; --SELECT * FROM users; --SELECT gender, WHERE AVG(salary) AS avg_salary --FROM users --GROUP BY gender; SELECT users.name, addresses.city FROM users INNER JOIN addresses ON users.id = addresses.user_id; SELECT * FROM users;