rearrange columns and use aliases

INSERT INTO University (University_ID, University_Name) VALUES
  (2467548, "University of Illinois Urbana Champaign"),
  (5873461, "Illinois State University"),
  (3236472, "University of Chicago");
INSERT INTO Course (Professor, Course_No, Section, Credit_Hours, Course_Name, University_ID) VALUES
  ("J.W. Morrisette", 101, 003, 3, "Intro to Theatre", 1492059),
  ("Ryan Nerd", 451, 002, 2, "Advanced Gaming", 2467548),
  ("Jesus Christ", 131, 007, 4, "Transubstantiation", 1492059),
  ("Bruce Flachsbart", 270, 003, 3, "Gears", 2467548),
  ("Englie Ish", 105, 004, 2, "Words and Letters", 3236472),
  ("Johann Bach", 250, 002, 3, "Composition and Music Theory", 3236472),
  ("Michael Jordan", 325, 005, 1, "Slam Dunk", 2467548),
  ("I. M. Talking", 83, 001, 0, "History of Gossip", 5873461);
INSERT INTO Student (Username, ID, Major, University_ID, Course_No) VALUES
  ("easanga1", 6329864, "Costume Design", 1492059, 101),
  ("jpanell2", 5437269, "Mechanical Engineering", 2467548, 270),
  ("snagesh43", 3478295, "Computer Science", 2467548, 451),
  ("mbiehl7", 3738298, "English", 3236472, 105),
  ("brucey98", 1294874, "Music", 3236472, 250),
  ("sincz55", 7234829, "Recreation and Sport Tourism", 2467548, 325),
  ("jamen1", 3740144, "Religion", 1492059, 131),
  ("jbirch69", 1337420, "Communications", 5873461, 083);

/*Need to add Scrim back into Materials*/
INSERT INTO Materials VALUES(3, "Scrim", 0.76);
/*Need to add None as an option in Finishes table*/
INSERT INTO Finishes VALUES(4, "None", 0.00); 

/*need to populate values in Signs table*/
INSERT INTO Signs VALUES (1,2,3,1,3,2,12.00);
INSERT INTO Signs VALUES (2,3,2,2,2,1,5.72);
INSERT INTO Signs VALUES (3,6,3,1,1,1,10.80);
INSERT INTO Signs VALUES (4,9,3,2,2,2,38.74);
INSERT INTO Signs VALUES (7,4,4,5,4,4,98.56);
INSERT INTO Signs VALUES (8,6,4,5,4,1,36.96);
INSERT INTO Signs VALUES (9,3.25,4,5,4,1,20.02);
INSERT INTO Signs VALUES (10,3,4,5,4,1,18.48);
INSERT INTO Signs VALUES (11,3,4.5,5,4,1,20.79);
INSERT INTO Signs VALUES (12,2.25,3.25,4,4,1,5.56);
INSERT INTO Signs VALUES (13,4.5,3,1,1,1,8.46);
INSERT INTO Signs VALUES (14,9,3,1,2,1,15.86);
INSERT INTO Signs VALUES (15,9,3,2,2,2,38.74);
INSERT INTO Signs VALUES (16,1.33,2,1,4,2,2.77);
INSERT INTO Signs VALUES (17,3,1,1,4,1,1.56);
INSERT INTO Signs VALUES (18,2,3,2,4,1,3.90);
INSERT INTO Signs VALUES (19,3,2,1,4,1,3.12);

/* Concatenated name and cost with reader friendly language and used alias of Available Materials for that column*/
SELECT concat( name, ' costs ', cost, ' per square foot.') AS "Available Materials" FROM Materials ORDER BY cost;

/* Displayed only certain columns, reordered them, concatenated vertical and horizontal dimensions into a more readable format with aliases*/
SELECT quantity AS "Quantity", concat(hor_dimens, "\' x ", vert_dimens, "\'") AS "Dimensions", cost AS "Cost" FROM Signs;

SELECT peopleid, surname, first_name, born, died 
FROM people;

SELECT title AS old_title, year_released 
FROM movies 
WHERE year_released < 1990;

/* query 1 */

SELECT /* column order is rearranged */
    articles.title, 
    upper(articles.body) as content, /* alias */
    articles.article_id,    
    COUNT(ReplyJoin.comment_id) as replies_count /* alias */
FROM 
    articles
LEFT JOIN /*!! left join is used here because we want to get all articles with or without comments.*/
    comments AS ReplyJoin /* bonus alias */
ON 
    ReplyJoin.article_id = articles.article_id
WHERE 
    (articles.body like '%SWEET%' and articles.user_id < 4) or articles.title like '%blandit%'
GROUP BY 
    articles.article_id
HAVING 
    COUNT(ReplyJoin.comment_id) > 1
ORDER BY 
    articles.title
;

/* query 2 */

SELECT /* column order is rearranged */
    lower(articles.title) as lower_title,  /* alias */ 
    GROUP_CONCAT(comments.body SEPARATOR ' + ') AS comment_summary, /* alias */
    articles.article_id
FROM 
    articles
LEFT JOIN /*!! left join is used here because we want to get all articles with or without comments.*/
    comments
ON 
    comments.article_id = articles.article_id
WHERE
    articles.article_id < 5 and LENGTH(articles.body) > 50 and comments.parent_id is not NULL
GROUP BY 
    articles.article_id
HAVING
    NOT comment_summary like '%bart%'
ORDER BY
    LENGTH(articles.body) ASC
;