https://www.youtube.com/watch?v=RjZFC6NVUMc&list=PLavw5C92dz9Hxz0YhttDniNgKejQlPoAn&index=4

drop table if exists Q4_data;
create table Q4_data
(
	id			int,
	name		varchar(20),
	location	varchar(20)
);
insert into Q4_data values(1,null,null);
insert into Q4_data values(2,'David',null);
insert into Q4_data values(3,null,'London');
insert into Q4_data values(4,null,null);
insert into Q4_data values(5,'David',null);

select * from Q4_data;

SELECT * FROM Q4_Data;

SELECT MIN(id) AS id,MAX(Name) AS Name,MAX(location) AS Location
FROM Q4_Data;

SELECT * FROM Q4_Data;

SELECT MAX(id) AS id,MAX(Name) AS Name,MAX(location) AS Location
FROM Q4_Data;