SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE members
    ([member_id] int primary key, [first_name] varchar(11), [last_name] varchar(11), [email] varchar(32), [gender] varchar(6), [member_state] varchar(12))
;
    
CREATE TABLE ratings
    ([rating_id] int primary key, [movie_id] int, [member_id] int, [rating] int)
;

CREATE TABLE movies
    ([movie_id] int primary key, [movie_name] varchar(87), [movie_genre] varchar(34))
;

ALTER TABLE ratings ADD CONSTRAINT movies_fk FOREIGN KEY (movie_id) REFERENCES movies(movie_id);
    
ALTER TABLE ratings ADD CONSTRAINT members_fk FOREIGN KEY (member_id) REFERENCES members(member_id);
    
                
INSERT INTO members
    ([member_id], [first_name], [last_name], [email], [gender], [member_state])
VALUES
    (1, 'Roby', 'Dauncey', 'rdauncey0@shareasale.com', 'Female', 'Maryland'),
    (2, 'Isa', 'Garfoot', 'igarfoot1@goo.gl', 'Female', 'Louisiana'),
    (3, 'Sullivan', 'Carletto', 'scarletto2@oracle.com', 'Male', 'Florida'),
    (4, 'Jacintha', 'Beacock', 'jbeacock3@wordpress.com', 'Female', 'Louisiana'),
    (5, 'Mikey', 'Keat', 'mkeat4@virginia.edu', 'Male', 'New York'),
    (6, 'Cindy', 'Stenett', 'cstenett5@weebly.com', 'Female', 'California'),
    (7, 'Alexina', 'Deary', 'adeary6@cnbc.com', 'Female', 'California'),
    (8, 'Perkin', 'Bachmann', 'pbachmann7@reference.com', 'Male', 'Texas'),
    (9, 'Laurie', 'Beebe', 'lbeebe8@cnbc.com', 'Female', 'Nebraska'),
    (10, 'Suzann', 'Genery', 'sgenery9@dailymail.co.uk', 'Female', 'Nebraska'),
    (11, 'Bonni', 'Bennellick', 'bbennellicka@elpais.com', 'Female', 'Texas'),
    (12, 'Jessica', 'Suter', 'jsuterb@blogtalkradio.com', 'Female', 'Oregon'),
    (13, 'Katya', 'O''Scannill', 'koscannillc@privacy.gov.au', 'Female', 'Missouri'),
    (14, 'Elmore', 'Kibel', 'ekibeld@livejournal.com', 'Male', 'Missouri'),
    (15, 'Rosemonde', 'Singers', 'rsingerse@xing.com', 'Female', 'Texas'),
    (16, 'Carlie', 'Iddon', 'ciddonf@newyorker.com', 'Male', 'New York'),
    (17, 'Star', 'Kitteridge', 'skitteridgeg@ca.gov', 'Female', 'Florida'),
    (18, 'Helli', 'Marzellano', 'hmarzellanoh@prnewswire.com', 'Female', 'Colorado'),
    (19, 'Isabeau', 'McInulty', 'imcinultyi@thetimes.co.uk', 'Female', 'Oregon'),
    (20, 'Felicity', 'Vigne', 'fvignej@fotki.com', 'Female', 'Kansas'),
    (21, 'Talya', 'German', 'tgermank@prlog.org', 'Female', 'Pennsylvania'),
    (22, 'Barthel', 'Turbayne', 'bturbaynel@vinaora.com', 'Male', 'California'),
    (23, 'Twila', 'Coye', 'tcoyem@disqus.com', 'Female', 'California'),
    (24, 'Trix', 'Rarity', 'trarityn@ehow.com', 'Female', 'Indiana'),
    (25, 'Danika', 'Boribal', 'dboribalo@bluehost.com', 'Female', 'New York'),
    (26, 'Lula', 'Lefridge', 'llefridgep@gnu.org', 'Female', 'Pennsylvania'),
    (27, 'Myrah', 'Hazelgreave', 'mhazelgreaveq@purevolume.com', 'Female', 'Illinois'),
    (28, 'Bibi', 'Dugdale', 'bdugdaler@apache.org', 'Female', 'Indiana'),
    (29, 'Nap', 'Jankin', 'njankins@godaddy.com', 'Male', 'Ohio'),
    (30, 'Therese', 'Shellcross', 'tshellcrosst@ucoz.com', 'Female', 'Alabama'),
    (31, 'Linc', 'Conichie', 'lconichieu@blogtalkradio.com', 'Male', 'Kansas'),
    (32, 'Dasi', 'Rraundl', 'drraundlv@member_state.gov', 'Female', 'Iowa'),
    (33, 'Chick', 'Edeler', 'cedelerw@4shared.com', 'Male', 'California'),
    (34, 'Minnaminnie', 'Genny', 'mgennyx@reddit.com', 'Female', 'Louisiana'),
    (35, 'Blane', 'Castelletti', 'bcastellettiy@member_state.tx.us', 'Male', 'Ohio'),
    (36, 'Leese', 'Beldon', 'lbeldonz@thetimes.co.uk', 'Female', 'Georgia'),
    (37, 'Mill', 'Pinchbeck', 'mpinchbeck10@google.com', 'Male', 'Texas'),
    (38, 'Nat', 'Huckster', 'nhuckster11@github.io', 'Male', 'Louisiana'),
    (39, 'Horatius', 'Baukham', 'hbaukham12@bravesites.com', 'Male', 'Minnesota'),
    (40, 'Darby', 'Hewins', 'dhewins13@tmall.com', 'Male', 'New York'),
    (41, 'Bendicty', 'Willisch', 'bwillisch14@bbc.co.uk', 'Male', 'Delaware'),
    (42, 'Danita', 'McUre', 'dmcure15@canalblog.com', 'Female', 'Wisconsin'),
    (43, 'Merrily', 'Heindl', 'mheindl16@nps.gov', 'Female', 'Wisconsin'),
    (44, 'Ginger', 'Stanwix', 'gstanwix17@independent.co.uk', 'Female', 'Indiana'),
    (45, 'Willyt', 'Bezemer', 'wbezemer18@ycombinator.com', 'Female', 'Louisiana'),
    (46, 'Latrena', 'Duffit', 'lduffit19@dell.com', 'Female', 'Kansas'),
    (47, 'Illa', 'August', 'iaugust1a@ox.ac.uk', 'Female', 'Virginia'),
    (48, 'Steffen', 'Simmers', 'ssimmers1b@google.com', 'Male', 'Arizona'),
    (49, 'Ashil', 'Sanchez', 'asanchez1c@themeforest.net', 'Female', 'Kansas'),
    (50, 'Vivian', 'Franckton', 'vfranckton1d@istockphoto.com', 'Female', 'Louisiana')
;

INSERT INTO movies
    ([movie_id], [movie_name], [movie_genre])
VALUES
    (1, 'Stalingrad', 'Drama|War'),
    (2, 'Hell Is for Heroes', 'Drama|War'),
    (3, 'White Sheik, The (Sceicco bianco, Lo)', 'Comedy|Romance'),
    (4, 'Moog', 'Documentary|Musical'),
    (5, 'Angst', 'Drama|Horror'),
    (6, 'Kid Brother, The', 'Children|Comedy|Romance'),
    (7, 'Trial and Error', 'Comedy|Romance'),
    (8, 'Code Name Coq Rouge', '(no genres listed)'),
    (9, 'Family Guy Presents: Blue Harvest', 'Animation|Comedy'),
    (10, 'The Bloody Olive', 'Comedy|Crime|Film-Noir'),
    (11, 'Red Spectacles, The (Jigoku no banken: akai megane)', 'Comedy|Drama|Sci-Fi'),
    (12, 'Ulysses'' Gaze (To Vlemma tou Odyssea)', 'Drama|War'),
    (13, 'Ring of Bright Water', 'Comedy|Drama'),
    (14, 'Flight of the Conchords: A Texan Odyssey', 'Comedy'),
    (15, 'Last Days', 'Drama'),
    (16, 'My Dinner with André', 'Drama'),
    (17, 'Homicidal', 'Horror|Mystery|Thriller'),
    (18, 'Disneyland Dream', 'Documentary'),
    (19, 'Suriyothai (a.k.a. Legend of Suriyothai, The)', 'Action|Adventure|Drama|War'),
    (20, 'Notes on a Scandal', 'Drama'),
    (21, 'Tree of Life, The', 'Drama'),
    (22, 'Up Close and Personal', 'Drama|Romance'),
    (23, 'Cadillac Records', 'Drama|Musical'),
    (24, 'Summit, The', 'Documentary'),
    (25, 'Road Trip', 'Comedy'),
    (26, 'Support Your Local Gunfighter', 'Comedy|Romance|Western'),
    (27, 'Two Solutions for One Problem (Dow Rahehal Baraye yek Massaleh)', '(no genres listed)'),
    (28, 'Momma''s Man', 'Drama'),
    (29, 'Das Leben ist nichts für Feiglinge', 'Drama'),
    (30, 'Babe Ruth Story, The', 'Drama'),
    (31, 'Believer, The', 'Drama'),
    (32, 'Unprecedented: The 2000 Presidential Election', 'Documentary'),
    (33, 'Places in the Heart', 'Drama'),
    (34, 'Prinsessa (Starring Maja)', 'Drama'),
    (35, 'In Bloom (Grzeli nateli dgeebi)', 'Drama'),
    (36, 'Spirit Trap', 'Horror|Thriller'),
    (37, 'Great World of Sound', 'Comedy'),
    (38, 'Buccaneer, The', 'Adventure|Drama|Romance|War'),
    (39, 'Possessed (Besat)', 'Action|Crime|Drama|Horror|Thriller'),
    (40, 'Children Who Chase Lost Voices from Deep Below (Hoshi o ou kodomo) (Journey to Agartha)', 'Animation|Drama|Fantasy'),
    (41, 'Our Little Girl', 'Comedy|Drama|Romance'),
    (42, 'RV', 'Adventure|Children|Comedy'),
    (43, 'Little Manhattan', 'Children|Comedy|Romance'),
    (44, 'Shining, The', 'Horror'),
    (45, 'The Old Gun', 'Drama|Thriller|War'),
    (46, 'Love Games', 'Animation|Drama|Romance'),
    (47, 'Swiss Family Robinson', 'Adventure|Children'),
    (48, 'Wedding Gift, The', 'Drama|Romance'),
    (49, 'Rocco and His Brothers (Rocco e i suoi fratelli)', 'Crime|Drama'),
    (50, 'Happiness', 'Documentary')
;

insert into ratings (rating_id, movie_id, member_id, rating) values (1, 9, 34, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (2, 28, 32, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (3, 28, 31, 4);
insert into ratings (rating_id, movie_id, member_id, rating) values (4, 15, 48, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (5, 31, 40, 5);
insert into ratings (rating_id, movie_id, member_id, rating) values (6, 33, 26, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (7, 38, 21, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (8, 11, 49, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (9, 32, 10, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (10, 19, 24, 3);
insert into ratings (rating_id, movie_id, member_id, rating) values (11, 46, 6, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (12, 9, 32, 4);
insert into ratings (rating_id, movie_id, member_id, rating) values (13, 7, 11, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (14, 27, 19, 4);
insert into ratings (rating_id, movie_id, member_id, rating) values (15, 47, 34, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (16, 44, 35, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (17, 49, 17, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (18, 9, 39, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (19, 25, 17, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (20, 5, 13, 4);
insert into ratings (rating_id, movie_id, member_id, rating) values (21, 50, 50, 3);
insert into ratings (rating_id, movie_id, member_id, rating) values (22, 25, 45, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (23, 19, 32, 5);
insert into ratings (rating_id, movie_id, member_id, rating) values (24, 28, 3, 5);
insert into ratings (rating_id, movie_id, member_id, rating) values (25, 40, 47, 4);
insert into ratings (rating_id, movie_id, member_id, rating) values (26, 49, 13, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (27, 13, 29, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (28, 26, 18, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (29, 5, 37, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (30, 17, 17, 5);
insert into ratings (rating_id, movie_id, member_id, rating) values (31, 27, 13, 5);
insert into ratings (rating_id, movie_id, member_id, rating) values (32, 34, 37, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (33, 30, 28, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (34, 10, 4, 5);
insert into ratings (rating_id, movie_id, member_id, rating) values (35, 1, 37, 3);
insert into ratings (rating_id, movie_id, member_id, rating) values (36, 14, 24, 3);
insert into ratings (rating_id, movie_id, member_id, rating) values (37, 7, 15, 5);
insert into ratings (rating_id, movie_id, member_id, rating) values (38, 8, 9, 4);
insert into ratings (rating_id, movie_id, member_id, rating) values (39, 50, 47, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (40, 30, 35, 2);
insert into ratings (rating_id, movie_id, member_id, rating) values (41, 8, 26, 4);
insert into ratings (rating_id, movie_id, member_id, rating) values (42, 47, 36, 3);
insert into ratings (rating_id, movie_id, member_id, rating) values (43, 30, 40, 3);
insert into ratings (rating_id, movie_id, member_id, rating) values (44, 23, 16, 4);
insert into ratings (rating_id, movie_id, member_id, rating) values (45, 9, 13, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (46, 34, 12, 3);
insert into ratings (rating_id, movie_id, member_id, rating) values (47, 50, 31, 1);
insert into ratings (rating_id, movie_id, member_id, rating) values (48, 42, 28, 3);
insert into ratings (rating_id, movie_id, member_id, rating) values (49, 29, 18, 5);
insert into ratings (rating_id, movie_id, member_id, rating) values (50, 30, 46, 4);

select * from members;
select * from ratings;

select count(*) as member_count from members;

select 
	count(*) as rating_count,
	count(distinct member_id) as rater_count 
from ratings;

member_id	first_name	last_name	email	gender	member_state
1	Roby	Dauncey	rdauncey0@shareasale.com	Female	Maryland
2	Isa	Garfoot	igarfoot1@goo.gl	Female	Louisiana
3	Sullivan	Carletto	scarletto2@oracle.com	Male	Florida
4	Jacintha	Beacock	jbeacock3@wordpress.com	Female	Louisiana
5	Mikey	Keat	mkeat4@virginia.edu	Male	New York
6	Cindy	Stenett	cstenett5@weebly.com	Female	California
7	Alexina	Deary	adeary6@cnbc.com	Female	California
8	Perkin	Bachmann	pbachmann7@reference.com	Male	Texas
9	Laurie	Beebe	lbeebe8@cnbc.com	Female	Nebraska
10	Suzann	Genery	sgenery9@dailymail.co.uk	Female	Nebraska
11	Bonni	Bennellick	bbennellicka@elpais.com	Female	Texas
12	Jessica	Suter	jsuterb@blogtalkradio.com	Female	Oregon
13	Katya	O'Scannill	koscannillc@privacy.gov.au	Female	Missouri
14	Elmore	Kibel	ekibeld@livejournal.com	Male	Missouri
15	Rosemonde	Singers	rsingerse@xing.com	Female	Texas
16	Carlie	Iddon	ciddonf@newyorker.com	Male	New York
17	Star	Kitteridge	skitteridgeg@ca.gov	Female	Florida
18	Helli	Marzellano	hmarzellanoh@prnewswire.com	Female	Colorado
19	Isabeau	McInulty	imcinultyi@thetimes.co.uk	Female	Oregon
20	Felicity	Vigne	fvignej@fotki.com	Female	Kansas
21	Talya	German	tgermank@prlog.org	Female	Pennsylvania
22	Barthel	Turbayne	bturbaynel@vinaora.com	Male	California
23	Twila	Coye	tcoyem@disqus.com	Female	California
24	Trix	Rarity	trarityn@ehow.com	Female	Indiana
25	Danika	Boribal	dboribalo@bluehost.com	Female	New York
26	Lula	Lefridge	llefridgep@gnu.org	Female	Pennsylvania
27	Myrah	Hazelgreave	mhazelgreaveq@purevolume.com	Female	Illinois
28	Bibi	Dugdale	bdugdaler@apache.org	Female	Indiana
29	Nap	Jankin	njankins@godaddy.com	Male	Ohio
30	Therese	Shellcross	tshellcrosst@ucoz.com	Female	Alabama
31	Linc	Conichie	lconichieu@blogtalkradio.com	Male	Kansas
32	Dasi	Rraundl	drraundlv@member_state.gov	Female	Iowa
33	Chick	Edeler	cedelerw@4shared.com	Male	California
34	Minnaminnie	Genny	mgennyx@reddit.com	Female	Louisiana
35	Blane	Castelletti	bcastellettiy@member_state.tx.us	Male	Ohio
36	Leese	Beldon	lbeldonz@thetimes.co.uk	Female	Georgia
37	Mill	Pinchbeck	mpinchbeck10@google.com	Male	Texas
38	Nat	Huckster	nhuckster11@github.io	Male	Louisiana
39	Horatius	Baukham	hbaukham12@bravesites.com	Male	Minnesota
40	Darby	Hewins	dhewins13@tmall.com	Male	New York
41	Bendicty	Willisch	bwillisch14@bbc.co.uk	Male	Delaware
42	Danita	McUre	dmcure15@canalblog.com	Female	Wisconsin
43	Merrily	Heindl	mheindl16@nps.gov	Female	Wisconsin
44	Ginger	Stanwix	gstanwix17@independent.co.uk	Female	Indiana
45	Willyt	Bezemer	wbezemer18@ycombinator.com	Female	Louisiana
46	Latrena	Duffit	lduffit19@dell.com	Female	Kansas
47	Illa	August	iaugust1a@ox.ac.uk	Female	Virginia
48	Steffen	Simmers	ssimmers1b@google.com	Male	Arizona
49	Ashil	Sanchez	asanchez1c@themeforest.net	Female	Kansas
50	Vivian	Franckton	vfranckton1d@istockphoto.com	Female	Louisiana

rating_id	movie_id	member_id	rating
1	9	34	1
2	28	32	1
3	28	31	4
4	15	48	2
5	31	40	5
6	33	26	2
7	38	21	2
8	11	49	1
9	32	10	1
10	19	24	3
11	46	6	1
12	9	32	4
13	7	11	1
14	27	19	4
15	47	34	1
16	44	35	2
17	49	17	2
18	9	39	1
19	25	17	2
20	5	13	4
21	50	50	3
22	25	45	1
23	19	32	5
24	28	3	5
25	40	47	4
26	49	13	2
27	13	29	2
28	26	18	2
29	5	37	1
30	17	17	5
31	27	13	5
32	34	37	2
33	30	28	2
34	10	4	5
35	1	37	3
36	14	24	3
37	7	15	5
38	8	9	4
39	50	47	2
40	30	35	2
41	8	26	4
42	47	36	3
43	30	40	3
44	23	16	4
45	9	13	1
46	34	12	3
47	50	31	1
48	42	28	3
49	29	18	5
50	30	46	4

member_count
50

rating_count	rater_count
50	32

percentage
36.0000000000000

percentage
36.0000000000000

rating_id	movie_id	member_id	rating
1	9	34	1
2	28	32	1
3	28	31	4
4	15	48	2
5	31	40	5
6	33	26	2
7	38	21	2
8	11	49	1
9	32	10	1
10	19	24	3
11	46	6	1
12	9	32	4
13	7	11	1
14	27	19	4
15	47	34	1
16	44	35	2
17	49	17	2
18	9	39	1
19	25	17	2
20	5	13	4
21	50	50	3
22	25	45	1
23	19	32	5
24	28	3	5
25	40	47	4
26	49	13	2
27	13	29	2
28	26	18	2
29	5	37	1
30	17	17	5
31	27	13	5
32	34	37	2
33	30	28	2
34	10	4	5
35	1	37	3
36	14	24	3
37	7	15	5
38	8	9	4
39	50	47	2
40	30	35	2
41	8	26	4
42	47	36	3
43	30	40	3
44	23	16	4
45	9	13	1
46	34	12	3
47	50	31	1
48	42	28	3
49	29	18	5
50	30	46	4

rating_id	movie_id	member_id	rating
1	9	34	1
2	28	32	1
3	28	31	4
4	15	48	2
5	31	40	5
6	33	26	2
7	38	21	2
8	11	49	1
9	32	10	1
10	19	24	3
11	46	6	1
12	9	32	4
13	7	11	1
14	27	19	4
15	47	34	1
16	44	35	2
17	49	17	2
18	9	39	1
19	25	17	2
20	5	13	4
21	50	50	3
22	25	45	1
23	19	32	5
24	28	3	5
25	40	47	4
26	49	13	2
27	13	29	2
28	26	18	2
29	5	37	1
30	17	17	5
31	27	13	5
32	34	37	2
33	30	28	2
34	10	4	5
35	1	37	3
36	14	24	3
37	7	15	5
38	8	9	4
39	50	47	2
40	30	35	2
41	8	26	4
42	47	36	3
43	30	40	3
44	23	16	4
45	9	13	1
46	34	12	3
47	50	31	1
48	42	28	3
49	29	18	5
50	30	46	4

rating_id	movie_id	member_id	rating
1	9	34	1
2	28	32	1
3	28	31	4
4	15	48	2
5	31	40	5
6	33	26	2
7	38	21	2
8	11	49	1
9	32	10	1
10	19	24	3
11	46	6	1
12	9	32	4
13	7	11	1
14	27	19	4
15	47	34	1
16	44	35	2
17	49	17	2
18	9	39	1
19	25	17	2
20	5	13	4
21	50	50	3
22	25	45	1
23	19	32	5
24	28	3	5
25	40	47	4
26	49	13	2
27	13	29	2
28	26	18	2
29	5	37	1
30	17	17	5
31	27	13	5
32	34	37	2
33	30	28	2
34	10	4	5
35	1	37	3
36	14	24	3
37	7	15	5
38	8	9	4
39	50	47	2
40	30	35	2
41	8	26	4
42	47	36	3
43	30	40	3
44	23	16	4
45	9	13	1
46	34	12	3
47	50	31	1
48	42	28	3
49	29	18	5
50	30	46	4