我不知道如何格式化我的 FROM 语句以避免语法错误字符串文字

问：

我不知道为什么SQL无法识别语句中的表名。它返回一个语法错误，指出预期的字符串文字“peak-bit-402819.warehouse_orders。订单“在 [7：10] 我试图在 FROM 语句中加入双引号，但无济于事。编辑：我添加了我使用的两个表格的细节图片。我还尝试使用详细的表名，并得到在美国找不到的相同错误。请看图片。FROM

SELECT
    Warehouse.warehouse_id,
    CONCAT(Warehouse.state, ":", Warehouse.warehouse_alias) AS warehouse_name,
    COUNT(Orders.order_id) AS number_of_orders,
    (SELECT COUNT(*) 
     FROM 'peak-bit-402819.warehouse_orders.Orders' Orders) AS total_orders,
    CASE 
        WHEN COUNT(Orders.order_id)/(SELECT COUNT(*) FROM warehouse_orders.Orders Orders) <= 0.20
            THEN "fulfilled 0-20% of Orders"
        WHEN COUNT(Orders.order_id)/(SELECT COUNT(*) FROM warehouse_orders.Orders Orders) > 0.20
             AND COUNT(Orders.order_id)/(SELECT COUNT(*) FROM warehouse_orders.Orders Orders) <= 0.60
            THEN "Fulfilled 21-60% of Orders"
        ELSE "Fulfilled more than 60% of Orders"
    END AS fulfillment_summary
FROM  
    'peak-bit-402819.warehouse_orders.Warehouse' Warehouse
LEFT JOIN 
    warehouse_orders.Orders Orders ON Orders.warehouse_id = Warehouse.warehouse_id
GROUP BY
    Warehouse.warehouse_id,
    warehouse_name
HAVING
    COUNT(Orders.order_id) > 0

使用具有短表名的 FROM 语句

仓库表名称

订单表名称

使用带有反引号和完整表名的 FROM 语句