![\"sql\"](\"https:\/\/assignmentshark.com\/blog\/wp-content\/uploads\/2016\/03\/sql.png\")
<\/a><\/p>\nThe parameters used (such as filename and filesize) are subjective to the user and can be modified.<\/p>\n
A query can be executed by either clicking on the \u201cExecute” icon or pressing F5. It results in:<\/p>\n
We can notice that while the new database was created, its existence is not reflected in Object Explorer. In order to fix this, we should refresh Object Explorer window by pressing Refresh icon or pressing F5 when Object Explorer window is active.<\/p>\n In order for our next queries to interact with this database, we should mark it as the one currently used:<\/p>\n USE Sample<\/p>\n Result:<\/p>\n Next, we should create a new table called \u201cWorkers\u201d. The command should also specify the names and types (int for storing digits, char for storing characters\/strings) of table’s rows. First row will be used as unique row identifier (id), therefore marked as PRIMARY KEY. Additionally, since we do not plan any of these rows to contain no data, we will mark every of them as NOT NULL. This results in the following query:<\/p>\n CREATE TABLE Workers Results:<\/p>\n The rows should be filled with appropriate data:<\/p>\n INSERT INTO Workers(worker_id,worker_name,worker_age,worker_position) Results:<\/p>\n At this point, our table is created and filled with data, which allows us to start working on first out of four required queries, \u201cDisplay the total count of table entrances\u201d :<\/p>\n SELECT COUNT(*) Result:<\/p>\n Second query, \u201cDisplay all worker positions from this table\u201d, requires us to show the data based on specific column:<\/p>\n SELECT worker_position<\/p>\n FROM Workers<\/p>\n Result:<\/p>\n Third query, \u201cDisplay all rows from this table which correspond to workers over 30 years of age\u201d requires us to introduce a limit based on data in certain column:<\/p>\n SELECT * Result:<\/p>\n The last query is \u201cDisplay the total count of table entrances which correspond to workers under 40 years of age. This time try to give the result a meaningful name.\u201d SELECT COUNT(*) AS workers_under_40<\/p>\n FROM Workers<\/p>\n WHERE worker_age < 40<\/p>\n Result:<\/p>\n <\/p>\n The posted SQL sample was completed by one of AssignmentShark.com writers. If you can’t cope with your technical projects, we will provide online assignment help<\/a> you to solve any of the issues. Just specify your instructions and receive a completed assignment within a specified deadline.<\/em><\/p>\n If you are truly interested in completing IT assignments on your own, you can read one of another SQL code samples on database<\/a>. Or ask for help with SQL homework<\/a> one of our experts.<\/em><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":" MS SQL TASK: Create new MS SQL database. In this database, create a table with the following information: John Smith (age 31): cashier Mary Sue (age 42): cashier Mike Presley (age 35): shop assistant Bill Walker (age 29): guard Kate Davis (age 26): manager<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53,35],"tags":[],"class_list":["post-2819","post","type-post","status-publish","format-standard","hentry","category-it","category-samples"],"_links":{"self":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts\/2819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/comments?post=2819"}],"version-history":[{"count":13,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts\/2819\/revisions"}],"predecessor-version":[{"id":13563,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/posts\/2819\/revisions\/13563"}],"wp:attachment":[{"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/media?parent=2819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/categories?post=2819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmentshark.com\/blog\/wp-json\/wp\/v2\/tags?post=2819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/a><\/p>\n<\/a><\/p>\n
\n(
\nworker_id int NOT NULL PRIMARY KEY,
\nworker_name char(50) NOT NULL,
\nworker_age int NOT NULL,
\nworker_position char(50) NOT NULL
\n)<\/p>\n<\/a><\/p>\n
\nVALUES(1,’John Smith’,31,’cashier’)
\nINSERT INTO Workers(worker_id,worker_name,worker_age,worker_position)
\nVALUES(2,’Mary Sue’,42,’cashier’)
\nINSERT INTO Workers(worker_id,worker_name,worker_age,worker_position)
\nVALUES(3,’Mike Presley’,35,’shop assistant’)
\nINSERT INTO Workers(worker_id,worker_name,worker_age,worker_position)
\nVALUES(4,’Bill Walker’,29,’guard’)
\nINSERT INTO Workers(worker_id,worker_name,worker_age,worker_position)
\nVALUES(5,’Kate Davis’,26,’manager’)<\/p>\n<\/a><\/p>\n
\nFROM Workers<\/p>\n<\/a><\/p>\n<\/a><\/p>\n
\nFROM Workers
\nWHERE worker_age > 30<\/p>\n<\/a><\/p>\n
\nIt is a combination of approaches used in several previos queries, with the only new element being the addition of alias to the resulting column:<\/p>\n<\/a><\/p>\nSQL Assistance from the Experts<\/h2>\n