BDA Assignment Week 1

SQL

USE yiwiki_p;
SELECT * FROM revision LIMIT; 
SELECT * FROM revision ORDER by rev_timestamp;
SELECT rev_page FROM revision ORDER by rev_timestamp ASC;
SELECT rev_page, page_title, rev_timestamp FROM revision JOIN page ON rev_page = page_id ORDER by rev_timestamp ASC;
SELECT COUNT(rev_id) FROM revision WHERE rev_actor= "34973";
SELECT COUNT(rev_id) FROM revision GROUP by rev_actor;
SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by rev_actor ORDER BY editcounts DESC;
SELECT COUNT(rev_id) AS editcounts, rev_actor, user_name FROM revision JOIN user ON user_id = rev_actor GROUP by rev_actor ORDER BY editcounts DESC;
SELECT COUNT(rev_id) AS editcounts, rev_actor, user_name, user_registration FROM revision JOIN user ON user_id = rev_actor WHERE user_name NOT LIKE "%bot%" AND user_name NOT LIKE "%Bot%" GROUP by rev_actor ORDER BY editcounts DESC;
SQL

Checking query status...
