选择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.

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

我遗漏了什么？

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

‘