Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104. Expected Results OFFICE_NUM ADDRESS BDRMS FLOORS MONTHLY_RENT OWNER_NUM OCCUPIED 1 105 North Illinois Rd. NULL 1 1782.00 KO104 N 2 594 Leatherwood Dr. 5 2 2871.00 KO104 N ANSWER SOMEONE GAVE ME UPDATE LARGE_PROPERTY SET OCCUPIED = 'N' WHERE OWNER_NUM = KO104; ERROR 1054 (42S22) at line 1: Unknown column 'KO104' in 'where clause'
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.
Expected Results
OFFICE_NUM | ADDRESS | BDRMS | FLOORS | MONTHLY_RENT | OWNER_NUM | OCCUPIED |
---|---|---|---|---|---|---|
1 | 105 North Illinois Rd. | NULL | 1 | 1782.00 | KO104 | N |
2 | 594 Leatherwood Dr. | 5 | 2 | 2871.00 | KO104 | N |
![PROPERTY_ID
OFFICE_NUM
ADDRESS
SQR_FT
BDRMS
FLOORS
MONTHLY_RENT
OWNER_NUM
1
1
30 West Thomas Rd.
1600
3
1
1400
BU106
2
1
782 Queen Ln.
2100
4
2
1900
AK102
3
1
9800 Sunbeam Ave.
1005
2
1
1200
BI109
4
1
105 North Illinois Rd.
1750
3
1
1650
кО104
5
1
887 Vine Rd.
1125
2
1
1160
S1105
6
1
8 Laurel Dr.
2125
4
2
2050
MO100
7
2
447 Goldfield St.
1675
3
2
1700
Co103
8
2
594 Leatherwood Dr.
2700
2
2750
ко104
2
504 Windsor Ave.
700
2
1050
PA101
10
891 Alton Dr.
1300
3
1
1600
LO108
11
9531 Sherwood Rd.
1075
2
1
1100
J0110
12
2
2 Bow Ridge Ave.
1400
3
2
1700
RE107](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F41e4660d-a2b3-452c-b840-6ca128ad9286%2F143e4f62-e388-43a6-8970-f6caa4a9e0d0%2F2gkj7gr_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)