常用mysql

1.mysql 的sql语句实现查找Billing表，将Billing中账户为goldwind_it_application的11月份Date = '2024-11-01 00:00:00' 的是否报销Reimbursement ="是"的项目EnterpriseProject的12月份的所有信息查询到

SELECT sum(Cost) 
FROM Billing
WHERE Date = '2024-12-01 00:00:00'
AND AccountId= 'goldwind_it_application'
AND EnterpriseProject IN (
      SELECT EnterpriseProject
      FROM Billing
      WHERE MONTH(Date) = 11
        AND Date = '2024-11-01 00:00:00'
        AND Reimbursement = '是'
        AND Billing.AccountId = "goldwind_it_application"
  );

2.查找数据库中的费用

SELECT main_query.EnterpriseProject,
    main_query.Cost,
    main_query.Department,
    main_query.CostNo,
    main_query.WBS,
    main_query.BudgetNo,
    main_query.AccountId,
    ept.IntNum 
FROM (
    SELECT
        ep.EnterpriseProject,
        Cost,
        ep.Department,
        ep.CostNo,
        ep.WBS,
        ep.BudgetNo,
        b.AccountId
FROM Billing b
JOIN EnterpriseProject ep ON ep.EnterpriseProject=b.EnterpriseProject
WHERE MONTH(Date) = '12'
AND YEAR(Date) = '2024'
AND AccountId !="goldwind_dev_loads") AS main_query
LEFT JOIN 
    EnterpriseProjectTianrun ept ON main_query.EnterpriseProject=ept.EnterpriseProject;