BDA Assignment Week 1

SQL

USE yiwiki_p;
SELECT * FROM revision LIMIT 10; 
SELECT * FROM revision ORDER by rev_timestamp LIMIT 10;
SELECT rev_page FROM revision ORDER by rev_timestamp ASC limit 10;
SELECT rev_page, page_title, rev_timestamp FROM revision JOIN page ON rev_page = page_id ORDER by rev_timestamp ASC limit 10;
SELECT COUNT(rev_id) FROM revision WHERE rev_actor= "34973";
SELECT COUNT(rev_id) FROM revision GROUP by rev_actor LIMIT 10;
SELECT COUNT(rev_id) AS editcounts FROM revision GROUP by rev_actor ORDER BY editcounts DESC LIMIT 10;
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 LIMIT 10;
SQL

Checking query status...
