列出所有下过 2 个订单的客户 ID 和姓氏 [英] List all the customer IDs and last names who have made more than 2 orders

问题描述

我需要以下代码
客户表

I Need The Code For Following
Customer Table

CREATE TABLE customer (
  customer_id INTEGER PRIMARY KEY,
  first_name VARCHAR(255) NOT NULL,
  last_name VARCHAR(255),
  city VARCHAR(50) NOT NULL,
  State_ VARCHAR(50) NOT NULL,
  zip VARCHAR(7) NOT NULL
)

订单表

CREATE TABLE order_(
order_number INTEGER PRIMARY KEY NOT NULL,
Customer_ID integer FOREIGN KEY REFERENCES customer (customer_id) Not NULL,
Date_ date NOT NULL,
)

如何显示已下过 2 个订单的客户 ID 和姓氏请任何人帮忙

How To Display customer IDs and last names who have made more than 2 orders any one help please

推荐答案

SELECT customer_id, last_name
FROM dbo.customer
WHERE customer_id IN (
    SELECT Customer_ID
    FROM order_
    GROUP BY Customer_ID
    HAVING COUNT(*) > 2
)

这篇关于列出所有下过 2 个订单的客户 ID 和姓氏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！