{"id":260,"date":"2025-02-21T11:11:13","date_gmt":"2025-02-21T09:11:13","guid":{"rendered":"https:\/\/nikiforovnikitaportfolio.wordpress.com\/?page_id=260"},"modified":"2025-10-28T18:57:04","modified_gmt":"2025-10-28T16:57:04","slug":"sql-keel-harjutus-auto-tabeli-loomine","status":"publish","type":"page","link":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260","title":{"rendered":"SQL keel. Harjutus. Auto tabeli loomine."},"content":{"rendered":"\n<p>Loo tabeli<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE autode(\nMark VARCHAR(50)\n,reg_num VARCHAR (7)\n,Aasta int\n,Reg_piirk int);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-35.png?w=373\" alt=\"\" class=\"wp-image-264\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO autode( Mark, reg_num, Aasta, Reg_piirk)\nVALUES\n(&#039;Audi&#039;, &#039;123 ABC&#039;, 2000, 1)\n,(&#039;Ford&#039;,&#039;FIN 772&#039;,1988,2)\n,(&#039;Ford&#039;,&#039;777 AAA&#039;,2002,1)\n,(&#039;Nissan&#039;,&#039;111 CCC&#039;,2006,1)\n,(&#039;Toyota&#039;,&#039;128 HGF&#039;,2003,1)\n,(&#039;VAZ&#039;,&#039;544 CCH&#039;,1960,2)\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-34.png?w=402\" alt=\"\" class=\"wp-image-263\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-37.png?w=977\" alt=\"\" class=\"wp-image-267\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-38.png?w=270\" alt=\"\" class=\"wp-image-268\" \/><\/figure>\n\n\n\n<p><strong>\u00b7 J\u00e4rjesta autod tootmisaasta j\u00e4rgi kahanevasse j\u00e4rjekorda<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode ORDER BY Aasta DESC\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-39.png?w=273\" alt=\"\" class=\"wp-image-270\" \/><\/figure>\n\n\n\n<p><strong>\u00b7 V\u00e4ljasta k\u00f5ik erinevad margid (kasuta HAVING)<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT DISTINCT Mark FROM autode\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-52.png?w=108\" alt=\"\" class=\"wp-image-303\" \/><\/figure>\n\n\n\n<p><strong>\u00b7 V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode WHERE Aasta &lt; 1993;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-42.png?w=267\" alt=\"\" class=\"wp-image-275\" \/><\/figure>\n\n\n\n<p><strong>\u00b7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid t\u00e4hestiku j\u00e4rjekorras<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode WHERE Aasta &lt; 1993 ORDER BY Mark\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-43.png?w=255\" alt=\"\" class=\"wp-image-277\" \/><\/figure>\n\n\n\n<p><strong>\u00b7 V\u00e4ljasta autode k\u00f5ige varasem v\u00e4ljalaskeaasta (MIN)<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT MIN(Aasta) &#039;K\u00f5ige varasem v\u00e4ljalaskeaasta&#039; FROM autode\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-44.png?w=194\" alt=\"\" class=\"wp-image-279\" \/><\/figure>\n\n\n\n<p><strong>\u00b7 Muuda registrinumbrit autol, mille id on 3 (uus number 333 KKK)<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUPDATE autode SET reg_num = &#039;333 KKK&#039; WHERE reg_num = &#039;#45a2e7&#039;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-46.png?w=272\" alt=\"\" class=\"wp-image-283\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-47.png?w=267\" alt=\"\" class=\"wp-image-285\" \/><\/figure>\n\n\n\n<p><strong>\u00b7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Kustuta auto id-ga 4<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nDELETE FROM autode WHERE reg_num = &#039;#50c8a1&#039;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-45.png?w=266\" alt=\"\" class=\"wp-image-281\" \/><\/figure>\n\n\n\n<p><strong>\u00b7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Lisa uus masin nimekirja. Vaata tabeli sisu.<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO autode (Mark, reg_num, Aasta,Reg_piirk) VALUES (&#039;Nissan&#039;, &#039;555 NNN&#039;, 2002, 2)\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-48.png?w=274\" alt=\"\" class=\"wp-image-287\" \/><\/figure>\n\n\n\n<p><strong>Antud tabeli p\u00f5hjal koosta ise veel kolm SELECT p\u00e4ringu ja kommenteeri neid ja n\u00e4ita tulemust (print screen)<\/strong><\/p>\n\n\n\n<p>&#8220;Kuvada br\u00e4ndid, mille nimed algavad t\u00e4hega L ja mille asutamisaasta on p\u00e4rast 2000. aastat.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode WHERE reg_num LIKE &#039;%a%&#039; AND Aasta &gt; 2000\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-53.png?w=258\" alt=\"\" class=\"wp-image-307\" \/><\/figure>\n\n\n\n<p>K\u00f5ige vanem auto, millel on registreerimisnumber 1.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT TOP 1 * FROM autode WHERE Reg_piirk = 1 ORDER BY Aasta\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-54.png?w=246\" alt=\"\" class=\"wp-image-308\" \/><\/figure>\n\n\n\n<p>Kuvada ainult need autod, mille valmimisaste on ajavahemikus 2000\u20132010 ja mille registreerimisnumber on vahemikus 1 kuni 5.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode\nWHERE Aasta\nBETWEEN 2000 AND 2010\nAND Reg_piirk BETWEEN 1 AND 5\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-55.png?w=247\" alt=\"\" class=\"wp-image-309\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p><strong>J\u00e4rjesta autod tootmisaasta j\u00e4rgi kahanevasse j\u00e4rjekorda<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode ORDER BY Aasta DESC\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-56.png?w=526\" alt=\"\" class=\"wp-image-314\" \/><\/figure>\n\n\n\n<p><strong>V\u00e4ljasta k\u00f5ik erinevad margid (kasuta DISTINCT)<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT DISTINCT Mark FROM autode\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-57.png?w=252\" alt=\"\" class=\"wp-image-316\" \/><\/figure>\n\n\n\n<p><strong>V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode WHERE Aasta &lt; 1993;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-58.png?w=305\" alt=\"\" class=\"wp-image-318\" \/><\/figure>\n\n\n\n<p><strong>V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid t\u00e4hestiku j\u00e4rjekorras<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode WHERE Aasta &lt; 1993 ORDER BY Mark\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-59.png?w=411\" alt=\"\" class=\"wp-image-320\" \/><\/figure>\n\n\n\n<p><strong>V\u00e4ljasta autode k\u00f5ige varasem v\u00e4ljalaskeaasta (MIN)<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT MIN(Aasta) &#039;K\u00f5ige varasem v\u00e4ljalaskeaasta&#039; FROM autode; \n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-61.png?w=209\" alt=\"\" class=\"wp-image-323\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n\n<p><strong>Muuda registrinumbrit autol, mille id on 3 (uus number 333 KKK)<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUPDATE autode SET reg_num = &#039;333 KKK&#039; WHERE Reg_piirk=3; \n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-62.png?w=262\" alt=\"\" class=\"wp-image-325\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n\n<p><strong>Kustuta auto id-ga 4<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nDELETE FROM autode WHERE reg_num=&#039;#63fbbc&#039;;\n<\/pre><\/div>\n\n\n<p>Enne kui koodi sisestasin<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-63.png?w=266\" alt=\"\" class=\"wp-image-328\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n\n<p>P\u00e4rast koodi sisestamist kadus auto indikaatoriga 4<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-64.png?w=258\" alt=\"\" class=\"wp-image-330\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n\n<p><strong>Lisa uus masin nimekirja.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-65.png?w=643\" alt=\"\" class=\"wp-image-332\" \/><\/figure>\n\n\n\n<p><strong>Antud tabeli p\u00f5hjal koosta ise veel kolm SELECT p\u00e4ringu ja kommenteeri neid ja n\u00e4ita tulemust (print screen)<\/strong><\/p>\n\n\n\n<p>\u201cKuvada br\u00e4ndid, mille nimed algavad t\u00e4hega L ja mille asutamisaasta on p\u00e4rast 2000. aastat.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode WHERE reg_num LIKE &#039;%a%&#039; AND Aasta &gt; 2000\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-66.png?w=267\" alt=\"\" class=\"wp-image-333\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n\n<p>K\u00f5ige vanem auto, millel on registreerimisnumber 1.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode WHERE Reg_piirk = 1 ORDER BY Aasta LIMIT 1;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-67.png?w=255\" alt=\"\" class=\"wp-image-335\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n\n<p>Kuvada ainult need autod, mille valmimisaste on ajavahemikus 2000\u20132010 ja mille registreerimisnumber on vahemikus 1 kuni 5.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM autode\nWHERE Aasta\nBETWEEN 2000 AND 2010\nAND Reg_piirk BETWEEN 1 AND 5\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-68.png?w=246\" alt=\"\" class=\"wp-image-337\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n\n\n\n<p><strong>Koosta kolm protseduuri, mis sisaldavad v\u00e4hemalt 1parameeter ja see parameeter s\u00f5ltub SELECT lause tulemusest.<\/strong><\/p>\n\n\n\n<p><strong>Kindla aasta autode hankimise kord<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBEGIN\n    SELECT Mark, reg_num, Aasta, Reg_piirk\n    FROM autode\n    WHERE Aasta = year1;\nEND\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-70.png?w=598\" alt=\"\" class=\"wp-image-344\" \/><\/figure>\n\n\n\n<p>Tulemus, kui sisestate 2000 :<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-69.png?w=195\" alt=\"\" class=\"wp-image-342\" style=\"width:620px;height:auto\" \/><\/figure>\n\n\n\n<p><strong>P\u00e4rast m\u00e4\u00e4ratud aastat toodetud autode vastuv\u00f5tmise kord<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBEGIN\n    SELECT Mark, reg_num, Aasta, Reg_piirk\n    FROM autode\n    WHERE Aasta &gt; year1;\nEND\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-71.png?w=619\" alt=\"\" class=\"wp-image-346\" \/><\/figure>\n\n\n\n<p>Tulemus, kui sisestate 2000 :<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-72.png?w=220\" alt=\"\" class=\"wp-image-347\" \/><\/figure>\n\n\n\n<p><strong>Kuvab k\u00f5ik konkreetse automargiga autod<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBEGIN\n    SELECT * \n    FROM autode\n    WHERE Mark = mark1;\nEND\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-75.png?w=607\" alt=\"\" class=\"wp-image-353\" \/><\/figure>\n\n\n\n<p>Tulemus, kui sisenete Fordi :<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-76.png?w=203\" alt=\"\" class=\"wp-image-354\" style=\"width:600px;height:auto\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Loo tabeli \u00b7 J\u00e4rjesta autod tootmisaasta j\u00e4rgi kahanevasse j\u00e4rjekorda \u00b7 V\u00e4ljasta k\u00f5ik erinevad margid (kasuta HAVING) \u00b7 V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid \u00b7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid t\u00e4hestiku j\u00e4rjekorras \u00b7 V\u00e4ljasta autode k\u00f5ige varasem v\u00e4ljalaskeaasta (MIN) \u00b7 Muuda registrinumbrit autol, mille id on 3 (uus number 333 KKK) \u00b7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Kustuta auto id-ga [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-260","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL keel. Harjutus. Auto tabeli loomine. - Nikita Nikiforov Portfolio<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL keel. Harjutus. Auto tabeli loomine. - Nikita Nikiforov Portfolio\" \/>\n<meta property=\"og:description\" content=\"Loo tabeli \u00b7 J\u00e4rjesta autod tootmisaasta j\u00e4rgi kahanevasse j\u00e4rjekorda \u00b7 V\u00e4ljasta k\u00f5ik erinevad margid (kasuta HAVING) \u00b7 V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid \u00b7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid t\u00e4hestiku j\u00e4rjekorras \u00b7 V\u00e4ljasta autode k\u00f5ige varasem v\u00e4ljalaskeaasta (MIN) \u00b7 Muuda registrinumbrit autol, mille id on 3 (uus number 333 KKK) \u00b7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Kustuta auto id-ga [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Nikiforov Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-28T16:57:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-35.png?w=373\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=260\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=260\",\"name\":\"SQL keel. Harjutus. Auto tabeli loomine. - Nikita Nikiforov Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=260#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=260#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/nikiforovnikitaportfolio.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image-35.png?w=373\",\"datePublished\":\"2025-02-21T09:11:13+00:00\",\"dateModified\":\"2025-10-28T16:57:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=260#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=260\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=260#primaryimage\",\"url\":\"https:\\\/\\\/nikiforovnikitaportfolio.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image-35.png?w=373\",\"contentUrl\":\"https:\\\/\\\/nikiforovnikitaportfolio.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/image-35.png?w=373\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=260#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL keel. Harjutus. Auto tabeli loomine.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/\",\"name\":\"Nikita Nikiforov Portfolio\",\"description\":\"Noorem Tarkvarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#organization\",\"name\":\"Nikita Nikiforov Portfolio\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png\",\"contentUrl\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png\",\"width\":150,\"height\":137,\"caption\":\"Nikita Nikiforov Portfolio\"},\"image\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL keel. Harjutus. Auto tabeli loomine. - Nikita Nikiforov Portfolio","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260","og_locale":"et_EE","og_type":"article","og_title":"SQL keel. Harjutus. Auto tabeli loomine. - Nikita Nikiforov Portfolio","og_description":"Loo tabeli \u00b7 J\u00e4rjesta autod tootmisaasta j\u00e4rgi kahanevasse j\u00e4rjekorda \u00b7 V\u00e4ljasta k\u00f5ik erinevad margid (kasuta HAVING) \u00b7 V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid \u00b7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;V\u00e4ljasta enne 1993. aastat toodetud autode registrinumbrid t\u00e4hestiku j\u00e4rjekorras \u00b7 V\u00e4ljasta autode k\u00f5ige varasem v\u00e4ljalaskeaasta (MIN) \u00b7 Muuda registrinumbrit autol, mille id on 3 (uus number 333 KKK) \u00b7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Kustuta auto id-ga [&hellip;]","og_url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260","og_site_name":"Nikita Nikiforov Portfolio","article_modified_time":"2025-10-28T16:57:04+00:00","og_image":[{"url":"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-35.png?w=373","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260","name":"SQL keel. Harjutus. Auto tabeli loomine. - Nikita Nikiforov Portfolio","isPartOf":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260#primaryimage"},"image":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260#primaryimage"},"thumbnailUrl":"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-35.png?w=373","datePublished":"2025-02-21T09:11:13+00:00","dateModified":"2025-10-28T16:57:04+00:00","breadcrumb":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260#primaryimage","url":"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-35.png?w=373","contentUrl":"https:\/\/nikiforovnikitaportfolio.wordpress.com\/wp-content\/uploads\/2025\/02\/image-35.png?w=373"},{"@type":"BreadcrumbList","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=260#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"SQL keel. Harjutus. Auto tabeli loomine."}]},{"@type":"WebSite","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#website","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/","name":"Nikita Nikiforov Portfolio","description":"Noorem Tarkvarendaja","publisher":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":"Organization","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#organization","name":"Nikita Nikiforov Portfolio","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/","logo":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#\/schema\/logo\/image\/","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png","contentUrl":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png","width":150,"height":137,"caption":"Nikita Nikiforov Portfolio"},"image":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=260"}],"version-history":[{"count":1,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/260\/revisions"}],"predecessor-version":[{"id":1109,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/260\/revisions\/1109"}],"wp:attachment":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}