สอบถามวิธี Query มีทางไหนที่จะ Query ออกมาให้ได้แบบนี้บ้างครับ

SELECT bill.id,company.name,date_format(bill.startdate,'%d/%m/%Y'),bill.status,bill.idbill,date_format(bill.enddate,'%d/%m/%Y'),bill.Imoney,bill.infomation
FROM bill INNER JOIN company ON company.id=bill.id
ORDER BY bill.id

CREATE TABLE company (
id varchar(20) PRIMARY KEY unique,
name VARCHAR(30) NOT NULL,
address VARCHAR(100) NOT NULL,
tel VARCHAR(11) Not null,
email varchar(30));

CREATE TABLE bill
(
id varchar(20),
idbill int primary key not null AUTO_INCREMENT,
startdate date not null,
enddate date not null,
status varchar(30),
infomation varchar(50),
Imoney numeric(15,2),
pay numeric(15,2) default 0,
remain numeric(15,2) as (Imoney-pay),
FOREIGN KEY (id) REFERENCES company(id)
)