Find the total number of available beds per hosts' nationality

#Airbnb

Find the total number of available beds per hosts' nationality. Output the nationality along with the corresponding total number of available beds. Sort records by the total available beds in descending order.

table name: airbnb_apartments

table name: airbnb_hosts


Solution:

select h.nationality,sum(a.n_beds) as n_beds from airbnb_apartments as a
join airbnb_hosts as h on a.host_id = h.host_id
group by h.nationality
order by n_beds desc

Output:


SQL Script:

USE [StrataScratch]
GO
CREATE TABLE [dbo].[airbnb_apartments](
	[host_id] [int] NOT NULL,
	[apartment_id] [varchar](50) NULL,
	[apartment_type] [varchar](50) NULL,
	[n_beds] [int] NULL,
	[n_bedrooms] [int] NULL,
	[country] [varchar](50) NULL,
	[city] [varchar](50) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[airbnb_hosts](
	[host_id] [int] NULL,
	[nationality] [varchar](50) NULL,
	[gender] [varchar](50) NULL,
	[age] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (0, N'A1', N'Room', 1, 1, N'USA', N'New York')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (0, N'A2', N'Room', 1, 1, N'USA', N'New Jersey')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (0, N'A3', N'Room', 1, 1, N'USA', N'New Jersey')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (1, N'A4', N'Apartment', 2, 1, N'USA', N'Houston')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (1, N'A5', N'Apartment', 2, 1, N'USA', N'Las Vegas')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (2, N'A6', N'Yurt', 3, 1, N'Mongolia', N'-')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (3, N'A7', N'Penthouse', 3, 3, N'China', N'Tianjin')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (3, N'A8', N'Penthouse', 5, 5, N'China', N'Beijing')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (4, N'A9', N'Apartment', 2, 1, N'Mali', N'Bamako')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (5, N'A10', N'Room', 3, 1, N'Mali', N'Segou')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (5, N'A11', N'Room', 2, 1, N'Mali', N'Segou')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (6, N'A12', N'Penthouse', 6, 6, N'Luxembourg', N'Luxembourg')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (7, N'A13', N'Room', 4, 1, N'Luxembourg', N'Luxembourg')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (8, N'A14', N'Apartment', 2, 1, N'Australia', N'Perth')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (9, N'A15', N'Apartment', 2, 1, N'Australia', N'Perth')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (9, N'A16', N'Apartment', 2, 1, N'Australia', N'Perth')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (10, N'A17', N'Room', 4, 1, N'Brazil', N'Rio De Janeiro')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (10, N'A18', N'Room', 4, 1, N'Argentina', N'Mendoza')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (10, N'A19', N'Room', 4, 2, N'Uruguay', N'Mercedes')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (10, N'A20', N'Room', 4, 2, N'Brazil', N'Brasilia')
GO
INSERT [dbo].[airbnb_apartments] ([host_id], [apartment_id], [apartment_type], [n_beds], [n_bedrooms], [country], [city]) VALUES (11, N'A21', N'Apartment', 2, 2, N'Mexico', NULL)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (1, N'USA', N'F', 29)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (2, N'China', N'F', 31)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (3, N'China', N'M', 24)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (4, N'Mali', N'M', 30)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (5, N'Mali', N'F', 30)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (8, N'Australia', N'F', 33)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (9, N'Australia', N'M', 35)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (10, N'Brazil', N'M', 39)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (11, N'Brazil', N'F', 42)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (1, N'USA', N'F', 29)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (2, N'China', N'F', 31)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (3, N'China', N'M', 24)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (4, N'Mali', N'M', 30)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (5, N'Mali', N'F', 30)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (8, N'Australia', N'F', 33)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (9, N'Australia', N'M', 35)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (10, N'Brazil', N'M', 39)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (11, N'Brazil', N'F', 42)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (1, N'USA', N'F', 29)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (2, N'China', N'F', 31)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (3, N'China', N'M', 24)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (4, N'Mali', N'M', 30)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (5, N'Mali', N'F', 30)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (8, N'Australia', N'F', 33)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (9, N'Australia', N'M', 35)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (10, N'Brazil', N'M', 39)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (11, N'Brazil', N'F', 42)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (1, N'USA', N'F', 29)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (2, N'China', N'F', 31)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (3, N'China', N'M', 24)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (4, N'Mali', N'M', 30)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (5, N'Mali', N'F', 30)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (8, N'Australia', N'F', 33)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (9, N'Australia', N'M', 35)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (10, N'Brazil', N'M', 39)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (11, N'Brazil', N'F', 42)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (1, N'USA', N'F', 29)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (1, N'USA', N'F', 29)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (1, N'USA', N'F', 29)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (1, N'USA', N'F', 29)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (0, N'USA', N'M', 28)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (6, N'Luxembourg', N'M', 25)
GO
INSERT [dbo].[airbnb_hosts] ([host_id], [nationality], [gender], [age]) VALUES (7, N'Luxembourg', N'F', 25)
GO


Comments (0)
Questions List