{"id":510,"date":"2022-08-23T20:11:27","date_gmt":"2022-08-23T19:11:27","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=510"},"modified":"2022-08-23T20:24:11","modified_gmt":"2022-08-23T19:24:11","slug":"sql-query-design","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/sql-query-design\/","title":{"rendered":"SQL Query Design"},"content":{"rendered":"<p>It is important design any queries that needs to be implemented.<\/p>\n<p>The query design does not need to include specific SQL (Structured Query Language) commands. <strong>SQL commands will only be used during implementation<\/strong><\/p>\n<p>At the design stage, it is only necessary to state the following:<\/p>\n<ul>\n<li>fields<\/li>\n<li>tables<\/li>\n<li>criteria<\/li>\n<li>sort order<\/li>\n<\/ul>\n<p>Short hand can be used for the terms Ascending (<strong>ASC<\/strong>) and Descending (<strong>DESC<\/strong>).<\/p>\n<p>Below is a few examples to help you design your own queries<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23195840\/GetImage-3-1.jpeg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-511\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23195840\/GetImage-3-1.jpeg\" alt=\"\" width=\"410\" height=\"190\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23195840\/GetImage-3-1.jpeg 410w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23195840\/GetImage-3-1-300x139.jpeg 300w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Example 1<\/strong><\/p>\n<p>Design a query to show all records from the Films table where the Rating is equal to \u2018U\u2019.<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200750\/sql-design.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-512\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200750\/sql-design.png\" alt=\"\" width=\"572\" height=\"141\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200750\/sql-design.png 1046w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200750\/sql-design-300x74.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200750\/sql-design-1024x253.png 1024w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200750\/sql-design-768x189.png 768w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200750\/sql-design-624x154.png 624w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Example 2<\/strong><\/p>\n<p>Design a query to show the Title, Rating and Genre all records from the Films table where the Distributor is equal to \u201820 Century Fox\u2019.<\/p>\n<p><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200925\/sql-design1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-513\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200925\/sql-design1.png\" alt=\"\" width=\"572\" height=\"148\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200925\/sql-design1.png 1038w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200925\/sql-design1-300x78.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200925\/sql-design1-1024x265.png 1024w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200925\/sql-design1-768x199.png 768w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23200925\/sql-design1-624x162.png 624w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Example 3<\/strong><\/p>\n<p>Design a query to show Title and Running Time from the Films table for films where the Rating is equal to \u2018U\u2019 or \u2018PG\u2019, sort by Title Ascending Order.<\/p>\n<p data-reactid=\".1s08ljtqg1s.0.0.0.1:0.1.0.$0.$1.$4\"><a href=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23201035\/sql-design2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-514\" src=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23201035\/sql-design2.png\" alt=\"\" width=\"572\" height=\"141\" srcset=\"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23201035\/sql-design2.png 1042w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23201035\/sql-design2-300x74.png 300w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23201035\/sql-design2-1024x253.png 1024w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23201035\/sql-design2-768x189.png 768w, https:\/\/blogs.glowscotland.org.uk\/glowblogs\/public\/phsn5computingscience\/uploads\/sites\/10033\/2022\/08\/23201035\/sql-design2-624x154.png 624w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/a><\/p>\n<p data-reactid=\".1s08ljtqg1s.0.0.0.1:0.1.0.$0.$1.$4\">\n","protected":false},"excerpt":{"rendered":"<p>It is important design any queries that needs to be implemented. The query design does not need to include specific SQL (Structured Query Language) commands. SQL commands will only be used during implementation At the design stage, it is only necessary to state the following: fields tables criteria sort order Short hand can be used [&hellip;]<\/p>\n","protected":false},"author":79984,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-510","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/users\/79984"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/comments?post=510"}],"version-history":[{"count":19,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/510\/revisions"}],"predecessor-version":[{"id":533,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/510\/revisions\/533"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}