利用BETWEEN AND比较字符串获得一个首字母为 B 和 N 之间的数据问题

创建表和准备数据

CREATE TABLE customer
(
 customer_id serial ,
 title char(4) ,
 fname varchar(32) ,
 lname varchar(32) NOT NULL,
 addressline varchar(64) ,
 town varchar(32) ,
 zipcode char(10) NOT NULL,
 phone varchar(16) ,
 CONSTRAINT customer_pk PRIMARY KEY(customer_id)
);

INSERT INTO customer(title, fname, lname, addressline, town, zipcode, phone)
VALUES('Miss','Jenny','Stones','27 Rowan Avenue','Hightown','NT2 1AQ','023 9876');
INSERT INTO customer(title, fname, lname, addressline, town, zipcode, phone)
VALUES('Mr','Andrew','Stones','52 The Willows','Lowtown','LT5 7RA','876 3527');
INSERT INTO customer(title, fname, lname, addressline, town, zipcode, phone) 
VALUES('Miss','Alex','Matthew','4 The Street','Nicetown','NT2 2TX','010 4567');
INSERT INTO customer(title, fname, lname, addressline, town, zipcode, phone) 
VALUES('Mr','Adrian','Matthew','The Barn','Yuleville','YV67 2WR','487 3871');