SELECT count mysql

Question

我有一个名为Real_Estate_Lab_Project的数据库，我有一张名为listings的表，列名为listing price。

listing_key int PK 
listing_status int 
listing_type int 
date_listed date 
date_expires date 
date_unlisted date 
reason_unlisted int 
address varchar(50) 
city varchar(30) 
state char(2) 
zip_code varchar(10) 
lot_number varchar(50) 
residential_area int 
listing_price int 
listing_agreement_signed_date date 
remark varchar(1000) 

我正在尝试运行

USE Real_Estate_Lab_Project;
SELECT count(*) 
as no_of_listings, 
avg(price) as avg_listing_price, sum(listings) 
as sum_of_listings, min(price) 
as min_price, max(price) 
as max_price 
from Listing 
where status = 'Active'

当我运行脚本时，它告诉我

错误代码：1146。表"real_estate_lab_project.listing"不存在0.000秒，但我知道它存在，因为我在进行时可以看到它

SELECT * from listings.

日期过期列中确实有一些已过期，但有些尚未过期。

我错过了什么？

Answer 1

看起来您必须用sql 中的列表替换"Listing">

SELECT count(*) 
as no_of_listings, 
avg(price) as avg_listing_price, sum(listings) 
as sum_of_listings, min(price) 
as min_price, max(price) 
as max_price 
from listings
where status = 'Active

'