montgomerykarloxc24x
06.07.2019 •
Computers and Technology
Do the following sql questions. the resulting columns must all have descriptive names. you must show the result of the query. for example, if the query is:
show the office id, the city, and the region
your query should be:
select office, city, region
Solved
Show answers
More tips
- A Animals and plants Why do cats go crazy over catnip?...
- W Work and Career Everything You Need to Know About MBA Programs...
- S Sport How to Do Push-ups Correctly?...
- S Style and Beauty How to Grow Hair Faster: Real Methods and Advice...
- F Family and Home How to Remove Fading from Clothes: Tips and Tricks...
- F Food and Cooking How to Make Polendwitsa at Home?...
- F Family and Home Parents or Environment: Who Has the Most Influence on a Child s Upbringing?...
- P Philosophy Unbelievable stories of encounters with otherworldly forces...
- L Leisure and Entertainment How to Choose the Perfect Gift for Men on February 23rd?...
- H Health and Medicine How to Treat Whooping Cough in Children?...
Answers on questions: Computers and Technology
- C Computers and Technology _ is unsolicited junk mail. It can overcrowd your mailbox and deliver malware. PLEASE HELP ASAP!!...
- M Mathematics The area of a square poster is 31 in squared. Find the length of one side of the poster to the nearest whole inch...
- E English Wich is not an example of expository writing...
- M Mathematics Match the result of solving an equation to the number of solutions the equation has 3 = 3 no solution 6 = 3 infinitely many solutions one solution x=3...
- S Spanish 1. tarjeta de crédito (este) 2. centro comercial (aquel) 3. vendedora (aquel) 4. dependienta (aquel) 5. gafas (este) 6. mercado (ese) 7. zapatos de tenis (este) 8. cinturones...
- E English Let s catch some grub before kickoff It is imperative to develop cognitive skills at an early age. I like to eat dessert before the meal. My older sister makes delicious...
- M Mathematics Shelby mixes a 259 bleach solution with 5 cups of a 10% bleach solution, resulting in a 20% bleach solution. The table shows the amount of each solution used. Bleach...
- H History When the olympic games began in ancient Greece, only ___ were allowed to participate. A)men B)Spartans C)Athenians D)unmarried women...
- S Social Studies Which of the following would most likely result in Austin not being the capital of Texas...
- M Mathematics A number that is a whole number but not an integer?...
Ответ:
We can use CREATE command to create tables with columns having descriptive names
Explanation:
Firstly, create a table using CREATE command in SQL. The syntax is as follows:
CREATE TABLE [table_name]
(
[col_name] [datatype]),
[col_name] [datatype]),
[col_name] [datatype]),
[col_name] [datatype])
)
Once the table is created, we can insert the data into table using INSERT command. It's syntax is as follows:
INSERT INTO table_name VALUES('', '', '')
if datatype is string, values must be entered within single quotes. If datatype is int, values are entered directly without using quotes.
Now, you can select the data from the table using SELECT command. It's syntax is as follows:
SELECT column-list FROM table_name
If you want to filter rows according to conditions, you can use WHERE command.
I have created sample table and inserted some data into it. Now, I applied some queries on it to select data from the table.
I have written in a text file and attached the same. Please find. Thank you!
Ответ: