All public logs
Jump to navigation
Jump to search
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).
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)- 06:44, 27 September 2024 Andr3w talk contribs changed group membership for Cyberbob from (none) to teacher (requested by Edward Omeasoo <eomeasoo@ualberta.ca>)
- 10:59, 4 January 2023 Andr3w talk contribs changed group membership for Bdavison from (none) to administrator and teacher (Brian davison)
- 19:19, 26 November 2022 Andr3w talk contribs changed group membership for Abian from (none) to teacher (Translate to spanish)
- 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))
- 13:55, 4 September 2018 Andr3w talk contribs deleted page 059eab23-26f1-4051-8f09-a44dd26e808d (content was: " your...", and the only contributor was "Lekishawqffhduhvtohdexalpkirpmwfeqfiilbyvyglickson" (talk))
- 15:13, 10 May 2018 Andr3w talk contribs changed group membership for Nobuyukiinaba from (none) to teacher (Editing Japanese)
- 22:41, 21 April 2018 Andr3w talk contribs imported Special:Badtitle/NS828:String/doc by file upload (1 revision)
- 22:41, 21 April 2018 Andr3w talk contribs imported Template:Tlx by file upload (1 revision)
- 22:41, 21 April 2018 Andr3w talk contribs imported Template:Tl by file upload (1 revision)
- 22:41, 21 April 2018 Andr3w talk contribs imported Special:Badtitle/NS828:String by file upload (1 revision)
- 18:11, 20 April 2018 Andr3w talk contribs imported Template:Translatable template name by file upload (1 revision)
- 18:11, 20 April 2018 Andr3w talk contribs imported Template:Translatable by file upload (1 revision)
- 18:11, 20 April 2018 Andr3w talk contribs imported Template:TNTN by file upload (1 revision)
- 18:11, 20 April 2018 Andr3w talk contribs imported Template:Pagelang by file upload (1 revision)