let quotation = await this.prisma.quotation.findUnique({
where: { id },
include: {
statusHistory: {
orderBy: {
createdAt: 'desc',
},
take: 1,
},
byUser: {
select: {
firstName: true,
lastName: true,
},
},
project: {
include: {
ship: {
select: {
id: true,
name: true,
client: {
select: {
id: true,
name: true,
},
},
},
},
},
},
operations: {
orderBy: {
lineNumber: 'asc',
},
include: {
activities: {
select: {
id: true,
operationId: true,
estimatedHours: true,
actualHours: true,
type: {
select: {
id: true,
name: true,
number: true,
},
},
},
},
materials: {
select: {
id: true,
operationId: true,
description: true,
estimatedPrice: true,
retailPrice: true,
},
},
},
},
},
});
```
```js
const sql = Prisma.sql`SELECT (SUM("Activity"."estimatedHours") * "ActivityType"."multiplerValue") as "totalPrice" FROM "Activity" LEFT JOIN "ActivityType" ON "ActivityType"."id" = "Activity"."typeId" GROUP BY "Activity"."operationId", "ActivityType"."multiplerValue"`;
const result = await this.prisma.$queryRaw`${sql}`;
I want to be able to use below raw query inside the first query