From 81f0bb9a24e5f775256387b90b95cf2761ec18b8 Mon Sep 17 00:00:00 2001 From: Greg Wilson Date: Wed, 4 Dec 2013 10:08:16 -0500 Subject: [PATCH] Adding diagrams to novice SQL lessons --- sql/novice/02-sort-dup.ipynb | 2 +- sql/novice/03-filter.ipynb | 28 +- sql/novice/06-agg.ipynb | 44 +-- sql/novice/img/sql-aggregation.odg | Bin 0 -> 9965 bytes sql/novice/img/sql-aggregation.svg | 415 +++++++++++++++++++++++ sql/novice/img/sql-filter.odg | Bin 0 -> 10167 bytes sql/novice/img/sql-filter.svg | 510 +++++++++++++++++++++++++++++ 7 files changed, 962 insertions(+), 37 deletions(-) create mode 100644 sql/novice/img/sql-aggregation.odg create mode 100644 sql/novice/img/sql-aggregation.svg create mode 100644 sql/novice/img/sql-filter.odg create mode 100644 sql/novice/img/sql-filter.svg diff --git a/sql/novice/02-sort-dup.ipynb b/sql/novice/02-sort-dup.ipynb index 2f885c9..f09cdd0 100644 --- a/sql/novice/02-sort-dup.ipynb +++ b/sql/novice/02-sort-dup.ipynb @@ -383,7 +383,7 @@ "source": [ "### Challenges\n", "\n", - "FIXME: write challenges for sorting and removing duplicates" + "1. Write a query that displays scientists' full names, but orders them by surname." ] } ], diff --git a/sql/novice/03-filter.ipynb b/sql/novice/03-filter.ipynb index 1c7fa54..0182954 100644 --- a/sql/novice/03-filter.ipynb +++ b/sql/novice/03-filter.ipynb @@ -61,7 +61,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -79,13 +79,6 @@ "to determine what columns to display." ] }, - { - "cell_type": "markdown", - "metadata": {}, - "source": [ - "FIXME: diagram showing SQL processing pipeline executing a join that multiplies then filters records" - ] - }, { "cell_type": "markdown", "metadata": {}, @@ -116,12 +109,19 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], "prompt_number": 3 }, + { + "cell_type": "markdown", + "metadata": {}, + "source": [ + "\"SQL" + ] + }, { "cell_type": "markdown", "metadata": {}, @@ -150,7 +150,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -219,7 +219,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -261,7 +261,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -302,7 +302,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -341,7 +341,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], diff --git a/sql/novice/06-agg.ipynb b/sql/novice/06-agg.ipynb index 0f08a18..635a7f6 100644 --- a/sql/novice/06-agg.ipynb +++ b/sql/novice/06-agg.ipynb @@ -60,7 +60,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -102,6 +102,13 @@ ], "prompt_number": 3 }, + { + "cell_type": "markdown", + "metadata": {}, + "source": [ + "\"SQL" + ] + }, { "cell_type": "code", "collapsed": false, @@ -121,7 +128,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -157,7 +164,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -182,7 +189,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -207,7 +214,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -249,7 +256,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -282,7 +289,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -324,7 +331,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -369,7 +376,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -401,7 +408,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -439,7 +446,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -477,7 +484,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -521,7 +528,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -540,13 +547,6 @@ "alongside the aggregated `reading` values." ] }, - { - "cell_type": "markdown", - "metadata": {}, - "source": [ - "FIXME: diagram showing SQL processing pipeline with an extra stage for aggregation, and multiple records being compressed into one" - ] - }, { "cell_type": "markdown", "metadata": {}, @@ -589,7 +589,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], @@ -637,7 +637,7 @@ "metadata": {}, "output_type": "display_data", "text": [ - "" + "" ] } ], diff --git a/sql/novice/img/sql-aggregation.odg b/sql/novice/img/sql-aggregation.odg new file mode 100644 index 0000000000000000000000000000000000000000..ed2b9a03fca14e168999d1f5c6925d0ad491e0fa GIT binary patch literal 9965 zcmeHtWmsIx((Yiv-3cCGaDs-Q!Civ81{rJ!Ft{anf|TLQA+~0APOKIV#`cyVQ%B{$ z0FjW8{sO$m_%Hbj(9Fr0)z#J}Ots%`_9<4w854Y!W(brSh(pCtokjwEp+{NmORdSO z8-gdz=zQ1Yu2qsk6cDj8xIMrcbkSaB`}Wx}&}eFWB&^B+F$io1XK?-mwlV?ePa5 zEZPTSB=<}U=4!_+7Sz4S;a#qq=fRalK|>Ek!59l(Lg43Xm>3V%*WF~U$?UtSh@EvW ze!gYUl~BGB#lvRwnH)Fz`$a>Beo>MxzLX8U{49Esx?`DYiMoe%GWJ#L$-L~0o=0r! z(IZUVwX`5G3P$>f1lp~zt#jHbo}c=@i5e@zV1eVAOxETEveL__@&r_+$U*45qHO)%G`web3@_7SRoH}NZwyc?~Ie!py_ ze232_$^zoEe%25>tr~67)aY8;?&*;Y7Xy0zktC=2A2{xW0)B%y=pEqd_u|Js!pSx(H)8usnub?D*(d6SW$%!U? zwlH{UbctAeUW&yZX$m?N7qNqfS;ZRQU8#;|nO_1YT8qB}E5B+(PVU?*(HQ#s%_cQG z(Vnmz`FrItwSf`{yNc(YpU4*8e110nN-4B*ks4^=v4d&-%+ipqPy41o86oo^Dto0Y zs%#b1_X9PcGx^LFbk($Q^g%Y;Hypsx)uY?2)-T-*)pOgCy@7grYtJEEVx0qW8S!r_ zUf;?YA1{D1et`CYVPjp|#^<^jtY8- zM8~IfL|qeE+6pFD+hroiGlgqL%i;JCp{nn|U^Jw&ud*G=@J+x-aM3xsr)+|g_+CFY zaD)iGf6>e^8?zT}H#p%XYyT7WX2e)Ax=xt!o)fs2#v9CH<1YCr?P%J}U}Q|9 z9t_>cRgZby-~p>GoyZyK1+F+-au>`RV=ib4JrT98P9^#=+yuK*f$>IzhNIvYR!w3$ z*==@8xzzKjgAo7sUhaqs)D8IpO!-t9VgtlJm<3-N_I? zYUpO=_=aCrQ!dvaz`{={Xh8ah;y6oUo=*3i3B7O~fhXH{qx;XK^jHiRLOkqlmqKawu) zU>2TuP#ve0=$|1Qpt+Tf?+)i0Rf^udF6H+T!Fz}EyyQ*x$0iOfjFy8PL*DLchryBf zswHl&XW#H_63O(VXtGA+=!@^f(I{MH-6Exa#0Dk%y(ymREvE8%1OLINxWXL^HMv%p z!*Ej^TUSU1Yf3z-U6VjlZNo1-j7>lggF})+_!iF^##<4okV9sv8wY4tTo;KguIZ8W zJ~PoPsdr9GmAqoVe6{kZ*Ynw^HTBwH%9|%Zd6|LOT(W{=_bhLRG~JLHu`2R+$mp=& z!9SRU93HQ~<56U|z}1Iwsr0fr=TxpI>pt{Hl64NWLADBaK14B(O@@i(Y(vL9-DM+L zn^#hy$sie+>9nv*YNqXTY1VX{vbjKj-;=gIG9K{4kDqWp$w|%7qY~nzw+O74v6r}B z<8U8W2yYx)Z=>NOjN=TcSQjiL?GH_XujYA260Q${Jp-lhy3$cP-D1jE`K|NflWcOB z&`EPqbQ)`E*jJ_<>&g?U&swo@kbnL}dCBLP6j2FLB#m6%O|jfjKqJK0U#EWmg&p-} z?zhcr1o5}*u=rrjcNApd5k07$`d*v2E%j(-#4eB(+()Zi?F8;VYXF40D@2cQ|v^&kDaDqJEw>F^&xcX z&4nlP;x#Sg1?QheQ;1PgCCOK+R6d)HDpb_`stc>wM(~v5RrH43_G;6DP%n9MIzR?# zcz{=i?Q82A>5*4=x|dD%MtiqDQK-RF1y7tWv{1`YBq`Q|YfJ9<+w0SMfe%7Lw}&s{ zvSEu*hi32l(Q7xRS7e2Qk_!{=A7fyP+Mtj9KRDd&EAPlhM#p zkv02Wy)eZC)*X@oPwTS5tgGZ&NA9oLgH_f~j{=|??eS3SeOBZZ+Bd~PWiglNc=at2 zO+z`5q%KbNIlJnrJQ5ZqK5~ zEQOku3P-Dy@#jPn2}|&LzO190=g$4IVG19;zUlqNq{^y_@UA@PQAroBsBAtnW%4#@NeRf5+oQx4tUFgd zuEhSarvBq@32u#9my9bj=zEabe&hjajOX(ZE$V1on7X7yxwQ`dnG-{$^z=DyjMT<* zpLy-mY#K6wl7EjDv3^Nnn#Mi1hymVYFh?X;rNG-a@98z0c zXo_sc13EP&`DHX!qKP)jTCYyk&3FQ3kbcM@V^u6^ES^|iza-+0M_DrYHg6oP}J|RUHl1}hM_;=H;fNis@x;^QYJPt z87$nRjg>r>CMH<0{tPq9vk2j~8RUa?>3ojEaMaJ%{KaY7V+Jz&ql(WMv>hrdIoiVNU~;TEnppi$d?b~q;S z9e6=BHGe}aqaFmPq7Y#X=%hok=j#hCCUcdUF*T2#adu$6IolJa9gqd$rw9aoX=%~+ z&B1&7;Y-Kq2))B0TAQmkIw1}H=SrEU#|X5ZOpZgIISf;8`i#QA7`hpJO*rlGyTx^r zHt7yfWXGe@qglM=c%{cIru=G;Lu?t<+|oUsn1d~jN}qVaEU@^!Sx-&>wLEKlI=_Bi z9%29Rx#AS)>Me2I5QGFoC>Q0XiwfyX*{ht03A+3CiE`fhA~OAug5rEJDD|Y=RJrPz z#gH_k;?mU^aWiX=k|y%@`30?r-Iag*Af0qhLqBc6WIOr!M-jL0g=9BPcyTRmW-hDy zm?<#j?LI;n(js(^X(!dv%JHqO@WSdHrn=G$-jm6Ohcr8gIM=o<=^;YUA_zVo9d|`e zNM_Ul&#J_`zaEpS-dH4hUot*fR5K3ZN=?a5B5Yk$i~6YaN+G_oz`pH90*zr*8BDx& ziLboFvMizpR`2oaAyAP_vhNdv+E}|AcHx?OBB&usy8$#KKU1Y_Q!-#uzPD+QEBKcI^3x)|b~kG$-DdA2u&Ye0fTQw`+wOY`}5O}H=5qWB$^2t4|a^9I3#&>C6 z8eUC5j>zh_p&lUymJw$~?Zo$q*|c##n-?a}=(jN$Nln8xUF2-DNyN_GCw{F1$>O%C z90)!t+J9{8Zu2UA_E@WLoL(x$CqfLaO0bW<6~=iiY7Oe@6w(;MUc)naMo{%}*|xTJb?C00ci}RADYF=SmA&+IvikN0M6{)Qr^X(7^3l*6 z!_2Gw?3Hw)S`TS0V-Y`6-AiI79sa&LKg!trlTow@o-k@VZ<2EoP2v2qE$_P+J2=DT zcRAro9b|I%t>}jqOFv8#!A(ew1?amqvHqf|btPyIWs)G<%sjZuyy_#<8h999^K^4f zh`*F^&z{dCsLxK*dgY+77I-~)38JnXd{S8g3%WAsZ3=9R_Tq_oyEhejdd0nbvp0nS z;OVY~874rpZ)g_hfAo~|J-lU=p=fd&TjrNjIm_}L9KNf>o73rA!YM7>yANEIr>NGO zA$L}L2R;u|KSfs7b{ir9P^9#8>i@~U8Rd;U((e}q4+qix)URdcYtC^l@1yS`9GX&3ZS>w z7e|oZLr=ejYEhLt*t*6Wh?rJ0H~@MJan!~ytrS%OT4X0m!;(kG?y->bCOb4&z8INf8w6xWO{L4i9-452gi_?b@=%e}>-VDu%?wxJY zp#$IOk&jdcX<*Wtqo(ca(Gk#{`A#L~z=c%f4g39H##{wE8gxy)7pIRE7Ir93=A<-< zWvx64(G@!a*0$QjlCieWC3oFwmy@+x$XD3w&pKQ#x*N0kdxk~%HyXvt?&7H*Dop548El}o%6`@)w{p8wxhTuAbgc8RUIhiN!M0S)J%C4o?SG3 zfbalC==o~K-%r4twI`H5el73I>Ug`MyIVH!{eeqQ!}5As1=#I&zb14WvD9vlZz(8s ztap8K-@O0mi7-#xnj!NL9P0g$EklLe+QRHTOU_paOrkGe_uq*w;mcsh;IaR9+BpTW zp={F@kg>8oD%vEM33H$VM?xi^v!F-+yzhpYq8Mo?dK`S7qB<_4vO;rGF0^@lETJ;w zeye`c`8h_d~mHfI0Ikm~K(E%V^qc`F&`uY1Lubo-cG@GzXZ^M3c;T^imN z1kk=DsE^Li&gY$vU+-=*Ooxi8MAPazbaaJ`(zKX-A%4dxe9KFUf$wv^$gW_HnSk$a zULD9;9Y#C|OA>A4Vtu{W-~1))pnYyZXqcWFWXl@$w~4q%6X!wdl9@zs9sW+t}YS zewL(YVMdAZTU6cx2M+z16qQT}N#Z(6W3!K=fkzv$1&O#2D+l(Nl_lqeU^8lPM%(|!VX8l7G@_Oxiuts$t-EE&V z@dvcEu!M{bk}%=-nmPIETg|9lf#Q*wCk3o31!Nv<&h|EP>ss_~zZ41LS~&+c}e3gUlXf z9!VM*lHRZ_2^eYWy1Djj`J|%t)R(HBLL?ua1g;pRWAjp6y9Oe?_}$can837eJ&Aw?)9^xo*;z3j1( zCNL@U7LR+9PK_2dqwF6I`^*UDF^pOg;r9>R+Zx%d*L+7+%%6}!BGPBMqz$6c*E7U7hV!%p(DBMJaI*#S-Q55raDb?d=?Tn= zM*PupTE2O1XN};Ky9ZS6J=VR3MO_hLpptM|=3P|QWqISt__8n8kPi6=CoSI2r)A>J zY@9@D;U;eHyPc^(`;S2tyud3c4JYo3A2e}`o7V_EU~;U+4U^N=N7^fih|gHFvu$j)Gm|hHUoMph|Wnm^qw&LPTEb`{bsy9P1;SK@dw6 zmw$I?T>W&h-8+t?lW{4bwwL_1cC;NcY9FvBG$IC7*p4y`1-$ zoVM1~L%T^8i|I&>IJF^GrW2~xwZILp#74=F62>D0vXYvkCAchitn?`w25Kx@c^voI z*}3du*UvSORh0qX_hFvXy)gJPa4A37RXnX!#hop9sdzURF}&8Z71Kp4bHlfa)bZW3 zNW^ap?OV?L#lESl|CrBG)_0UBuD#?Ql7$)i`1nie#EXrdIAOt@%v@gY%zP)u+I*=4=dwXo0!C-3PjRQK2+APycnJ^@BX4&R67qRDYbssh-y(;I_+{R`hDo>)ef4qS> z3*un3=_c<#rag2hka)Ei%^9HNS4~ufvRK-nA8IIJ1xLQ+MJ|@xikG6+oFVKe5<&uAuiRiSQNHBx!{=>< zc1wee$B7hh3UlEKJl>T?%n2!odaWDK7dL3H#|a`}wHZet4oPrz=F`tu7f&6Dt*M8{ zd9jfmpFVa~$mFhuNC){EnEPw4jg~pCYPEvhOL?tWjEKO^*m|e3bA?=|M^dnRy*=Fn5bM?Eqf%*rpM1J6oQkPH9$AS z1pz$r04i~D@1(|JrsYW)g%U*omAD~9%q(fVWyAde(9W38)JVsN@5tI+zw&1Gqks;e z#rtvIHKVTBFLVSLm^50=SFLDz5V}ZJR%G0$vdT0BGH$kQ4z+4XzoAfJ0nP)W@WJ3A zqyZh}$2INdZ!s!X$T07&dU@QPSifapH0;=q7MJ*?%x_WV)!KjMW_w>V=($=syH!td zX1?3oY?N>F3f?|9l(ZR6%JTqG4C*B|eE7=MK{()I<`Vn-J^#}K-$(Jz%QMFp^yhV^ zOZ6Ou{1oY*l^ebvtni0Tevegui-)f_UqT+f;0L1^LU)jd(>-KW%$Oom+G%-nnB8dV zG>%%_`N`@9=b)v7NOs*I0inA}Ki`Si8ls>8Xr`y=Z6O^Z z$7$T1InUj|JS+=wZxcrfkO6=*xu46zKP~X^?-zIq5^5qWGK!LHw#IfKb2G=kwsbzK zw%WB*qBWi|QSZL_n1@WeV?5fFaRrb}!9zxaRps^(#woDPEl|xqF*m(xv=AKI9vajD z2KTz!%rN;F<7b?vwq}~82Sr?l?YJa&F>ndeM8{_^Iwq8W`W?hK)H!6b93p8z8*oNz z5NBT+pVR)tjU*O$n;ARRxpQ~ZOxB~<4Un^$uYB};Rr259Y6bb%LkmG@!yNc;xpiKG zaDm(B%n59eL#jf1EZ+OuT}VK zDgR$8FYjCTMJ|6;rTks%_g%V&I)+~&bx#F;uWIxm{t|~jApN4W|5KFwKcM`g zxc@@=`KCYg{gbCYklbG~{|A(RpuGR-efswYX{t|hre~7EfatMzeZo|6&@Z8rYWl}#}{V!~@tYiQH literal 0 HcmV?d00001 diff --git a/sql/novice/img/sql-aggregation.svg b/sql/novice/img/sql-aggregation.svg new file mode 100644 index 0000000..b090bc6 --- /dev/null +++ b/sql/novice/img/sql-aggregation.svg @@ -0,0 +1,415 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 619 + + + + + DR-1 + + + + + 1927-02-08 + + + + + 622 + + + + + DR-1 + + + + + 1927-02-10 + + + + + 734 + + + + + DR-3 + + + + + 1939-01-07 + + + + + 735 + + + + + DR-3 + + + + + 1939-01-12 + + + + + 751 + + + + + DR-3 + + + + + 1939-02-26 + + + + + 752 + + + + + DR-3 + + + + + 837 + + + + + MSK-4 + + + + + 1932-01-14 + + + + + 844 + + + + + DR-1 + + + + + 1932-03-22 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 1. select date + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 2. min + + + + + 1927-02-08 + + + + + 1927-02-10 + + + + + 1939-01-07 + + + + + 1939-01-12 + + + + + 1939-02-26 + + + + + 1932-01-14 + + + + + 1932-03-22 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 1927-02-08 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + \ No newline at end of file diff --git a/sql/novice/img/sql-filter.odg b/sql/novice/img/sql-filter.odg new file mode 100644 index 0000000000000000000000000000000000000000..9bf6023407194a0b47258d4393c7ed9bdded82c6 GIT binary patch literal 10167 zcmeHtWmp_bx9(uUHMj(K3l72EZ6FX_2e$x&O9&d=-Q6X)69PelYjA>VaEAl?yE)l= zpX~2`=hyvn*F0TQGu`X0>Zs_^!WTBuj0RT7v0KvsiGy{sMiyi;~JROgJ0j$lf zL5{9=AOkx)D{~_QM{`>nW+xkCCR+msa|b3{JCKdBtr6H7WaG$WYHwg?W^Ux5^amgu z9NZs(j~M?ge*l6U4VYZ4t-@5~ZBt)jwp^%_)T>us&0sT-)TiU;0qcM^QB}kQ1^VQ3 ze*5jr!~^m2YLhSaxlT+LPq^E8>%uOceUT|cz8do4E1ozha+aBLO?X#3+@j`7CPJYRx;fPM;!Npr;wEiH!Dq;x%>2r!4X}Qld zJ?eIi%cuOL6tQUdQG^xU;t+n0Ml+tHDUG664(-iLc@YI)i2D;5?gP2>2QG=O9b5HL zGxaGfRqi9>d;(piQlTlN-fs=?e@Bf_9PT+SsizfmmS~4`=JsU>6H$W)PG_%Dd?#CP zhQponl(mpxEtJx%u)L(MmCAT1NqcXewzlX|QBrh;o37gk34&f>?ZKJrnfCIy!cmfi zh08ib@NS0y0GOcxfPbEJq{r!Z0699E+n72$P5gr9g2O5&n)jhz)X`~{Cy7uS)k_}& z5s}Y?(q<&nx=Vho@9;Htqt?*wZ({tUc`83Beo0d}iIlV2zR=n)KSwMVX!YOQ!t%@Q z)zZCd*dT(qV9E5DI!^Ct?a#X?x*Nw*D3}N|dFMq4sg4CNvrTy{WxM&Y(QV<_@KcHu zMV!2XNTmEa7Yk(D;?%tMLXB|=wQcBeLOho`orPLSNcXDCTena{wK6XJuwu_X(^ASOZA}Povz8aqtEo!TGb{@_w@PP3N1Epn`xDuKh z@HYzTe&a8hLp7QmcH&fTK(;Ld>A04k#T8o4zY$N_jI_zbR$r@RA&7h@m+UhlHyRj^ z{i==-;(T~CcJA4}i5MpVK?GqO8ddLA6d&a!-FW;h?i#eeSKNenD!L4nSj>KUa?&~C zJtFjVyiyUrAZ#^y2_o&Q3aCO)JC*ZzRb2$*H4W-A@_TEhH@PYO2cwHr@vamB;({|6 zDs)+Q9hL+Yh0W%xT*AI>a;H@=g2Ki^4by650c1b;eLS?f50_OsbIING!nr?uF?)l; ze1q>PWn!n;6>6{X;=>hxCLt>=N@jjf-_mkP`UtA5DPDG)=sKZEuc51?ONWrt%zFmG z<3$l;H7&09gA&*IRaPer?j4Ldr0Zgz&}PSqtuu)W!?R?OWjAY+cg>v|`(G*>MnGun zl-7qSQfQ~@Sdw;)S*klcXxGgf_5)77_1%|1c- z0fc0`!1u-76R8h^FDsIAE-BK14>+dbVyPpFcn>k-L+g zrZZ_@!0RHpR!kg>r|-omu0ChL}?4ZTxZK16iF% zJc&&ZSs*igdC?dw5rLkI7ryZzzt=tG6y$9(nkp#zQv{{L{2MS9c@Wc?7>+3089Q5Z zRX(5Dq^YIlX3UjME|=I)8V{7DLSl3xtvoMqyIbsTjjtY~n%asV^Ep0r$I@4Ik44Ur zb*oh1A$1evfyK?t57SI1-tcvJ^w>SQ8H@?S)-{en8m@6_Q$MX2dkcE(L!PO*QbHVw z)gi<4?B0^Ghh7yM<+I0ZaEnpjHa;ib&@q*4?#S{AG)j0FC=CIeW0sRInL+G@DTMBl zqyEy4Obn(-=A-VaJn?uu@CR0y9E5ptO^kuU-ZYkw)_7lHg&W=Q$AN2H=&G>5O}kZ@ z5DFJa3=-4158G%3O|WD}5W^m(*Riq61qV3-3rBK7Terl~6VFE9DzQv}y5u6w1cEHRd!n5IzNOuoIi@rgD=EERc?VOTlHLYZ?*9PBFsHmTR26LJWd7 zf~H$6$Mkk&6(Fnl0XlQNAwOh|18T8#q?p>^GFFk1I+&ZOx+5R+H3RO${m#e^6~ zg)j4Fv^j)R^a`{r`G4BNTkVn@)rJhF3e#UB8;($O*uJP}?~gydKMI7c(Y|I%b?sg7 zdnp6L5vRR!7L$1uD-=U7#MpYV=%NNhkwti8705YZ(`>M<<2XY1n6T7^r_D?(s%g5I?Iwv8)L8J zzb6&j)N6q(Y2YeU_2=sP-DEp#%yDe(I!gJ}{ULHuWmPi)wUx*QJC5Cw)+LeI@(u4A z*fZGhJ2NBF(~=w0 zK*1=5^XY;Jcb%2W-ReR{$+(cahU%0gFqluI&`$=|_|wqxPBN!j^=|N4-K0mz9p-9q zh4^rVsBa@}g>g*P=w>LkT>#k@>umF6V2^yva}LR07hSUSylga;19-|>kv^Jo?r*zx&~ zE_OQl^B-o?`WO{bq(vE%3EtS*n-7_o)}^2i14NI7P?sNsFZp&>kI zS_qfGJdQu(o%$G(LLuR1cHHKrY@Q*v%T^?G6+^d+q2tDYO{y^_J@N6=Y;F+Ubesm3 z^b6vT7M=GmK!PeG4t*g$v0My97#z&Gv?T-fd!?DVFNm8u!?Ni2x-6F%lZ{}<^U#|k ztA*L~`C;9GZ=VU9WD-;jf*WCh_6 z=00Yz>wFY+MWu{gwqN7uyw?jFir<62501p|03~ZFKU>F=&~in-n@pBd4(6&HZ9L=G z{P3}jGTGlt6=h_;(rRGe?74wznbNl}6^j{qHJ8tuwx<-Q&0>HU3K$ESurid^6LW-j*^ko$aCNZ#$!3y%(#57G+(d4v&e6XEp*4&Z@1I>NpFg zh3K4CZx--)nR=bo;Wdt`Mc=m^LTSHBA&EQIVq!73Ui3-Bk0oHT*}Z7of=|V9Q&YGn zb?>k`$ry%GdM9oAfiv#L3S@{U{=HngcC;kH&_CM9FhV<1r@WGT8X{ulE#zM6Vq&Ex zLE%A~yOv~6GPqymt~TB4k_>94JQ^#SgMZyZ7do&R!OD})vZ+*~ljwliP$cS^+rXRY zijK)e))#BLWeBd3)&8+QRP*bkz&eiBiXIgs514Y4$YX%shgjs5A(ZH2fT@r5%*SWO z)^zjh_du$9O9^k<6!m2bTUylPGqpUv-dU0UW&C0rJ=z$e8qNbokc!7wB9e9Cw#DLD zSe_JVjfArgb_sz}vtxtzz_x(G$8!*Ey8f{@!zI#N+xsOT?a!Tt_OC3?rf;sdx4ATK zSzU#~@z)splwZ-;uj;(W1`)`)Te^B6m!A(Q`+Bra-rbUzve6RQx1S_;M4-5p5}&;h zJUBx6fdR8#qBB);(z<5fInQ(pM0|%ip|vuOl>?(!tBxcfnpC%3avuDN%UqZXJ+w^6 zov>+jPo1#oHtt^7Q6odj@r$xmfSK`)>TDO4w!`;35R}doHTJ?$5H4Z_Ts0+`+zR?z zZE!XRm-&aFag9rPY z38opb7$Y&o-x`Xl1L|=h-9MRX5F@FMT>%v4AQWJrO0{1=CW7^x_`9IkUEX20FLE$N z3>T{_jsy>54lXsoEOgTg`SO+^FRYiir}1`Mbvqw5*6x%<)Xm_cDll!X4qJsGJJ>l1 z5PLh(3yd}nua!tbEp=~B7gsRPt$sG%)Ah)k*q%{TXD^%BNb?SV7CO!A&I{|UpX%Lw zf?#XApHtJ6e0bAb6Oev*J6;oz{eYuaFv;P$bZCN~+;%d}hAh8yN`S9h0;@arBOj;jf;%%TvQ%*PT7$vy%&5gz4Ir`Q%Bl2~f+tPt%gqr#jlVQ{42%jVl6uy6Ob zBfA)JblaV8D0w>!!DEKjCuUssxm(V&3@~-sYsk=9xwMs7l(r;rl*l1!k1&M|MUoe! zvD%K_g3}E{M4iZoZWWG#r=EEpU+LFViVCTB%mw`n$t$m6^5Uj_+`pE+*4y_O2e&uI z-7wE3XD^A`*W!Qrk_WZBCb9vEYkf}yB+Bu;N+^X5j{V~8rv{sJ5h6MJYQgm(Z@hg` zG)jbobH|LxI48Ufa%1_>2@c^vc10R$%`akK1(wIw@zOHwUakz|m||8TZttNTbI{DaQ_`E_E~R5l=m&_lg}b4%}V6{NZi)uLbg~pcNEsOS@UXt8reUdV`V7C7Y?((f2HvP< zGkYO(?IJ_an`-OU>w;+6ib7lt*!8USo9yOCpLE?#BxxPDCbimzqi4?BF=?bl+wDqT{o)c@nhF-i(@P!q)i0HBM2CTF z7xs4PH*1bA)a_;B&n#qgFWbrsB&-x+8ce<+a?F&7!6yt!Qod}$Zl2TU z>)|Je*eIxydA1X_x_vd6(^}qZ6M==yG%jJ|4K>}IJRg?S-E{(WCXplkwf?vxOuK#Y zO2FB2t$fIq?NT3=UrAK@>mjkP`>?XpM^oHFT8*PHE7#^oSN*BR7-e0L6)o)}#-SR8 zmrC^co6Z$Sg4XBb&m=Rzi^<-Jdg;N2g(Yl(lv{8k%)T?=HAfQ)Uby0Ci)qdvS z`Vee;FL~esGvDqjKTISxBbX6MT6g^&>Ey&lg=|$c4Yl-Ajq!p{XMgEN-D7&di0{F` z$F|7M=uq#-wTv&xx9su-$!u7e0I9M_>QVQu)IGFNs=$M%@v`y!`l#d_SkpVVe&TXG z{23+%Dj~LRJR@ike1qMAY%c53B{@hFP1{$izIYm_i=M3(iB89kwOdISUX+hd18hqA zp|=puuupkw)SciO?`B52ZJ&@lxipatvnvi1c%`4Qi{eZq<4R3T8a)P+07I<i#=pj>evw`D&kd3ePW=DH|Fbce5k$(z359rtLB0n*|MV&x+G@BbCn`)TQ) z&ioYO$BL+}jfuG_*#3{OumdZzxwU~Q$bnhJ+|k;=&Vl)#mGOV0Y-ei+wtEaDga4O$ zj<&W|b_O;etN*2*gQI~X*ul`i{@>^k{;r?)wx;$VhyRP_(?a<7;d$!mzi;n%T2Djr zOY3)Gb?V==Wng3kvI0HMjIBMh5!l}T{{#`B9s{+oPhoh#)1vz%|2#>*>x_w&t$`!x z=aBubGf&IAgQKez=wHEJ?L(XIoEQ&YiUx&So-t=V-iBA4wC8Tz%kK_WNA~yul*-u6 z(SmN-g`YFCWGzIt;(!1+xj>a}%Oqd0(!u$eW-hV)>cW2e8$L z;SE9JM_V~t-X0FLe+@hOys#uNLPG|z7{E@WlKQrKIS?9$Z7UT^i?W47Cf=HsPO9pw zQg8?(Y8`uz#)A3W)M9^@YKX_o%mJ`*A?3TIKwb67{;Bx=WmKMhvvco=mz8N2Vq#sh zq@&el4;c%&#WVJ==+x9|d{h)SZkAoCn_2_k4lhpb3>9XF?D>YPb8A?*%}$S_DS`Az z45|7oZwz=GdWyj+gQIV5{A}iOOXWNVB}9F>U!_c@u0X1G=zJP@i)wMP{bSdFD_IA% z86wdaw`!CxreCL+q4P*p!*9QhcJ-*^)}~aEB=*7Mdb^iCKAcE)%PA89w@sKi75cE9?N#$95Sa_LSY*~&5fiY8$er2A&PsNReE_HM?L5s)`D{O#rb$*ZEDVX) zAPc#OAI7ZpoT~^m6=wJQ3!js9Q`ug*swE+@vbvTj&Ru-xv-IM+v1Zgx%{RMy^d@Xq z-UdTuM^P*YxndOKip5X(aE_x}S6O{i-C|+7D>{KVQ3B|mHBxrH*_=I;C>~jR~pLoAu*r=P;tHdcmA&uV` zwkr-HMb@tbl|xUj~cPH8fO)k-7R^ zg8jF(YTK~)xs92D(Vxo$D2DIp_l)WKD2p@MCx40VZh!3c&Qd5do zQ_;oK8ffdT&HdPfeS6tB%#J?t{FeL6wFG$NUczX`S0ZmZPy#KAO7>mraC-e5XV*-5d<_gD^RA#4Iq7A6`7!5Vq*ZctS}T#mb+dXq($veA>Yk zK(9;@V{rw>)KAjgV#@VQ6CbqT!wokClEpK=e`)w7Hp*6Y4<0S37sc#UR>Ka1XsxMN znMOg5std{>_rugPuu)>}SANIa$-zh>6Kvz~ zdf1;1uqz9!;ikUHrC@u$=9`_0W$;EKxT;w|NwjQh$!y}NUL$Gx$i$+g(W z_Xde@E!^xH*WO9n_s2b&rZzIEeQT;Tg%`oGf1P)=BCtyY6U?%aLOE0 z)Il~Suksw{lA&ZK8DxoB)b5Dp?se;A)`A$qX(ol`B$ualq-2?%Sq+&pMzQ<#gvK|| zl-dNdCZA163Un&-Hrh~j&8o(sO{zr<0a=v7Bt0oq)N19JA!za~q&%Gt=^b}BUx)S( zDwI+Y>a%HpEsQ2rEE}n}J(F4`%ES#uv1KIG$I72GJ}}Xws_CjS?iR3;kR~tWl)8Lu z0IvfF--U#E%=AHENkgS>umC+QRK%Q2xkDhH$ z_=(QHe!a1nt)$~1UfOugF)RZyTt@IUZBl5vH(roGFDswhE344ap|LPmZCYR6JWC{% zDVdI}g(CHJuPX^mRIFDN>qy2ALdZs%{MOK2#kZnZ=W8-})=h6@D>~e3Ju*Ofil0Bn z#_JBH72nw-L#WQtD@%vLyX)=V311B38l$ny7}U z%Y{(d2cGSQEVpjmMP_SrSkr^yOKM4Hll{3e4;3oy9x3ZRqlkD?ZrpRdS_3ZJ@1{tX zlMsn2x+~H@na*um;uH1~^ZVkc;O{Ya9lH45-R1fPtwn@4#*7IkwBLIHSydbRFS8j$ zXAk%$y>&!-p(^wHVxq}{`E1LC5kSYeT|wDrZdvG*E`9fU(T18947Rsn?W0_7Kzjyk zIIpv?^w<~S^}+_Mtwb}-zyJ}>>Kes#PBN^Q3aWK(mmv7uz0|@3vxurkiy&A?` z(1kSlXzA5HnXFq-^ul~01g=TDl4e(_@u_ht_9HDoH-2;l+H7s~d?<8RNVnaIXT&d| zuF$=uEukJ}cO*N7D9s*MuRWDd=blCbA?d_WGZ~&1NKWYSmb3q5$4#N#=EyXkiPExfH&$Bio4UA5QqXAkje|L)VaQ{>c5b(s_`>9%uU)^; z${5-%Ka{W?O48#9Ry5aBbmZ9B#a__=YW5oaGKBZ#(Yt2}PTyxwuV^ltj8>aji+PDN zJ}R{=AFc6*O)ba1evgTzy;%Mte90F=;RDrC0Y=ZTMJZjXbVaw>-EmHdnnX?LZC z5ZjQMy>L#`5H^k*aNyOMs1J~b{^h~oSbNj-N9*txc-nfF#OfKT+PiSa@bPL77fuUz z5KnI5^ZTUHB6tAcLiVRy_&Wy=>(RlJ7grT#lva>nwl=UaHvu{Pu|ZX)^2z2i2~z6? zJ=uXzSphudzQI^q<_$n16%!r_Qia1?5TnRCzepwL%*5!X)s%mHZ+J+JI;hXZYL?#H z04wu6?Nb&gBQWARY~MNM3oSc8MRYA6CUe(FXLpAdAZiN<`BaN_Pz30$WHh)gNcgc{* z3_d0;wqt+AQY8@x1#BsG2~1d)Go-74lowLqr{Yh#`1iozFGV)A ze-0D=9p#r60PsXQe+d!x|KwQzgM$8b#D6IR08b?JmuUV5?9Y_+KgEgu4bGn_>VJyU z{~Me?Q`UdRc_OX91oAPg`gbB~_ZJHL&qz-U@R#uY2I&{2{ZCQse}nRi;{FTe=ac@_ z_D`PrL~?&g;crm>f%5*l=jpFE`0yLhUxfFsUHh}Ge4@O+gyRwP7Xkj+`p;YXvpIOO gq`w54>>uo^k}S-#r_0bDKb((Q1D20j0|3B(0ckvgKmY&$ literal 0 HcmV?d00001 diff --git a/sql/novice/img/sql-filter.svg b/sql/novice/img/sql-filter.svg new file mode 100644 index 0000000..3d79561 --- /dev/null +++ b/sql/novice/img/sql-filter.svg @@ -0,0 +1,510 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 619 + + + + + DR-1 + + + + + 1927-02-08 + + + + + 622 + + + + + DR-1 + + + + + 1927-02-10 + + + + + 734 + + + + + DR-3 + + + + + 1939-01-07 + + + + + 735 + + + + + DR-3 + + + + + 1939-01-12 + + + + + 751 + + + + + DR-3 + + + + + 1939-02-26 + + + + + 752 + + + + + DR-3 + + + + + 837 + + + + + MSK-4 + + + + + 1932-01-14 + + + + + 844 + + + + + DR-1 + + + + + 1932-03-22 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 1. where site = 'DR-1' + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 619 + + + + + DR-1 + + + + + 1927-02-08 + + + + + 622 + + + + + DR-1 + + + + + 1927-02-10 + + + + + 844 + + + + + DR-1 + + + + + 1932-03-22 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 619 + + + + + 622 + + + + + 844 + + + + + + + + + + + + + + + + + + + + + + + + + 619 + + + + + 622 + + + + + 844 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 2. select ident + + + + + + + \ No newline at end of file -- 2.26.2