{"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 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=\"(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 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=\"(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 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=\"(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 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=\"(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}]}}