All public logs

Combined display of all available logs of SQLZoo. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 08:18, 19 April 2024 Andr3w talk contribs created page File:Sa1.png
• 08:18, 19 April 2024 Andr3w talk contribs uploaded File:Sa1.png
• 22:00, 8 January 2024 Andr3w talk contribs created page File:Movie-er-2024.png
• 22:00, 8 January 2024 Andr3w talk contribs uploaded File:Movie-er-2024.png
• 10:21, 8 January 2024 Andr3w talk contribs blocked Unknown user talk with an expiry time of indefinite (account creation disabled, autoblock disabled, cannot edit own talk page) (As requested by user)
• 16:25, 12 November 2023 Andr3w talk contribs created page Andr3w (Created page with "==Pages that control everything== *MediaWiki:Common.js *MediaWiki:Common.css *MediaWiki:Sidebar *Special:RecentChanges *Special:SpecialPages Language Test Page ==My Pages== *User:Andr3w/vector.js ==Setting up a server - nginx== sudo apt-get build-essentialsudo apt-get install nginx sudo apt-get install mysql.server #Set root password for mysql sudo mysql_secure_installation sudo apt-get install php-fpm php-mysql sudo apt-get install ph...")
• 15:01, 24 September 2023 Andr3w talk contribs created page File:1999.png
• 15:01, 24 September 2023 Andr3w talk contribs uploaded File:1999.png
• 10:05, 22 September 2023 Andr3w talk contribs created page File:Sa.png
• 10:05, 22 September 2023 Andr3w talk contribs uploaded File:Sa.png
• 10:04, 22 September 2023 Andr3w talk contribs created page File:Ga.png
• 10:04, 22 September 2023 Andr3w talk contribs uploaded File:Ga.png
• 17:32, 10 April 2023 Andr3w talk contribs created page Easter2023 (Created page with "==Easter 9th April 2023== London 20 Princes Avenue NW22 Andrew Cumming dob 20-05-1962 file:portrait-in-turn.mov")
• 23:48, 14 May 2022 Andr3w talk contribs created page File:Cn-logo-dark-9824.svg
• 23:48, 14 May 2022 Andr3w talk contribs uploaded File:Cn-logo-dark-9824.svg
• 07:26, 11 May 2022 Andr3w talk contribs created page LaurenTest (Created page with "{{Languages}} <div class="ref_section"> <table class='db_ref'><caption>world</caption> <tr><th>name</th><th>continent</th><th>area</th> <th>population</th><th>gdp</th></tr> <tr><td>Afghanistan</td><td>Asia</td><td class="r">652230</td><td class="r">25500100</td><td class="r">20343000000</td></tr> <tr><td>Albania</td><td>Europe</td><td class="r">28748 </td><td class="r">2831741 </td><td class="r">12960000000 </td></tr> <tr><td>Algeria</td><td>Africa</td><td class="r">2381...")
• 07:23, 11 May 2022 Andr3w talk contribs changed group membership for LAUREN1996 from (none) to teacher (Working on Chinese translation)
• 18:03, 5 May 2022 Andr3w talk contribs created page HTL (Created page with "This page created for Hannes Grundschober to edit")
• 22:16, 3 May 2022 Andr3w talk contribs created page Join BabySteps (Created page with "200px|thumb|left|Music database <p>This tutorial introduces the notion of a join. The music has two tables: <code>album</code> and <code>track</code> in a one-to-many relationship. </p> album('''asin''', title, artist, price, release, label, rank) track('''<i>album</i>, dsk, posn''', song) <p> <div style='clear:both'></div> <div class='qu'> Find the <code>asin</code>, <code>title</code> and <code>artist</code> for the album with title Revolv...")
• 22:07, 3 May 2022 Andr3w talk contribs created page File:Music.png
• 22:07, 3 May 2022 Andr3w talk contribs uploaded File:Music.png
• 11:06, 3 May 2022 Andr3w talk contribs created page GRUH (Created page with "==Warming up== <div class='qu'> Read the notes about this table. Observe the result of running a simple SQL command. <source lang='sql' class='def'> SELECT name, region, population FROM bbc </source> <source lang='sql' class='ans'> SELECT name, region, population FROM bbc </source> </div>")
• 22:15, 2 May 2022 Andr3w talk contribs changed group membership for GRUH from (none) to teacher (Teacher in Austria)
• 14:38, 2 May 2022 Andr3w talk contribs created page File:DuplicatesGame.png
• 14:38, 2 May 2022 Andr3w talk contribs uploaded File:DuplicatesGame.png
• 07:24, 2 May 2022 Andr3w talk contribs created page File:Cardgamepic.png
• 07:24, 2 May 2022 Andr3w talk contribs uploaded File:Cardgamepic.png
• 17:36, 21 September 2021 Andr3w talk contribs changed group membership for A3nm from (none) to teacher
• 06:36, 14 May 2020 Andr3w talk contribs changed group membership for Fhossain27 from (none) to teacher (Fixing grammar)
• 09:29, 21 April 2020 Andr3w talk contribs created page Window LAG (Created page with "==COVID-19 Data== Notes on the data: This data was assembled based on work done by [https://github.com/pomber/covid19 Rodrigo Pombo] based on [https://systems.jhu.edu/research...")
• 17:07, 20 April 2020 Andr3w talk contribs changed group membership for Uhuh from (none) to bureaucrat and teacher (Improving the buses quiz)
• 17:10, 13 April 2020 Andr3w talk contribs created page SQL with CS (Created page with "The namespace System.Data.SqlClient includes the SqlCommand class that has all you need to run SQL from C# using System; using System.Data.SqlClient; class Program { st...")
• 10:03, 24 March 2020 Andr3w talk contribs created page SELECT basics/es (Created page with "{{Languages}} <div class="ref_section"> <table class='db_ref'><caption>world</caption> <tr><th>name</th><th>continent</th><th>area</th> <th>population</th><th>gdp</th></tr> <t...")
• 20:59, 6 March 2020 Andr3w talk contribs changed group membership for Jasvazquez from (none) to teacher (Translation into Spanish)
• 12:15, 15 January 2020 Andr3w talk contribs created page File:Movie2-er.png (ER diagram for movie database)
• 12:15, 15 January 2020 Andr3w talk contribs uploaded File:Movie2-er.png (ER diagram for movie database)
• 11:28, 23 November 2019 Andr3w talk contribs created page Window functions (Created page with "General Elections were held in the UK in 2015 and 2017. Every citizen votes in a '''constituency'''. The candidate who gains the most votes becomes MP for that constituency.")
• 15:40, 14 August 2019 Andr3w talk contribs created page Tmp (Created page with "==Large Countries== <div class='qu'> How to use WHERE to filter records. Show the name for the countries that have a population of at least 200 million. 20...")
• 18:34, 11 August 2019 Andr3w talk contribs changed group membership for Andr3w from bureaucrat, administrator and teacher to bureaucrat, administrator, teacher and interface administrator (Allow Andr3w to edit)
• 21:59, 29 July 2019 Andr3w talk contribs deleted page The JOIN Albums (Author request: content was: "{{Languages}} <div class="ref_section"> <table class='db_ref'> <caption>album</caption> <tr> <th>id</th> <th>mdate</th> <th>stadium</th>...", and the only contributor was "Andr3w" ([[User t...)
• 21:51, 1 April 2019 Andr3w talk contribs changed group membership for TuoUp from bureaucrat and teacher to (none)
• 21:21, 1 April 2019 Andr3w talk contribs changed group membership for TuoUp from (none) to bureaucrat and teacher (Edit Chinese version)
• 10:44, 25 March 2019 Andr3w talk contribs changed group membership for Sqlzoo.qa from (none) to administrator, bureaucrat and teacher (Admin account)
• 10:18, 17 December 2018 Andr3w talk contribs changed group membership for Udi from (none) to teacher (udioron@gmail.com)
• 10:15, 17 December 2018 User account Udi talk contribs was created by Andr3w talk contribs
• 13:58, 4 September 2018 Andr3w talk contribs deleted page RuthannIorio236 (content was: "What really caused the eurozone crisis? World leaders probably spent more time worrying about the eurozone crisis t...", and the only contributor was "46.105.61.253" (talk))
• 13:57, 4 September 2018 Andr3w talk contribs deleted page Bokep 3gp (content was: " [http://mp...", and the only contributor was "Neldafjyhkcikkhyqszwupgacjbpuvhbjgkfwispmaroudas" (talk))
• 13:57, 4 September 2018 Andr3w talk contribs deleted page Is361adelothman (content was: "", and the only contributor was "Is361adelothman" (talk))
• 13:56, 4 September 2018 Andr3w talk contribs deleted page Meebo tech support Number@1-855-800-8493)Meebo customer support phone number (content was: "Meebo tech support Number@1-855-800-8493) Meebo customer support phone number usa canada,Meebo support phone Number,Meebo customer ser...", and the only contributor was "Mamksmk" (talk))
• 13:56, 4 September 2018 Andr3w talk contribs deleted page Manoj (content was: "declare @v int set @v=1 print @v", and the only contributor was "14.140.124.84" (talk))

DataWars: Practice Data Science/Analysis with +100 Real Life Projects