展示2013年未能满足这一要求的设施,以及2013年至少有1次拉票失败的inspection.Show、设施名称和检查次数。使用子查询SELECT DBAName, COUNT(*)WHERE Risk = 1 AND [InspectionType] IN (SELECT [Inspection Type] FROM FoodInspectionOriginal WHERE [Inspection Type] = &
WHERE AND (a.inspection_date=b.inspection_date OR a.inspection_date IS NULL AND b.inspection_date IS NULL)
AND (a.deficiency_taga.deficiency_tag IS NULL AND b.deficiency_tag
Main.component.html <div class="box" *ngFor="let inspectionof inspectionList let index=index; let odd=odd; let even=even">
<app-inspection [inspect]="<