Changes between Version 1 and Version 2 of AdminManagesGenres

Timestamp:

08/24/26 16:03:09 (13 days ago)

Author:

211099

Comment:

--

AdminManagesGenres

@@ -8 +8 @@
 **2.** The system displays all existing genres and their usage counts.
 {{{#!sql
-SELECT g.genre_id, g.name, COUNT(hg.story_id) AS stories_using_genre
+SELECT g.genre_id, g.genre_name, COUNT(hg.story_id) AS stories_using_genre
 FROM GENRE g
 LEFT JOIN HAS_GENRE hg ON g.genre_id = hg.genre_id
 GROUP BY g.genre_id
-ORDER BY g.name ASC;
+ORDER BY g.genre_name ASC;
 }}}
 
@@ -20 +20 @@
 {{{#!sql
 SELECT * FROM GENRE
-WHERE LOWER(name) = LOWER('Science Fiction');
+WHERE LOWER(genre_name) = LOWER('Science Fiction');
 }}}
 
 **5.** The genre does not exist, so the system inserts it.
 {{{#!sql
-INSERT INTO GENRE (name)
+INSERT INTO GENRE (genre_name)
 VALUES ('Science Fiction');
 }}}