Explore - Need for more advanced querying options

### Problem Statement

Hey Team, I have an interesting use case where I wanted some thoughts on,
Customer's question:
We have a span with description appStartTtiInvestigation
And another span with operation network.client.execution
In network.client.execution we have property telemetry.response.protocol

**I want to see p90 of TTI span for the users that reports QUIC in telemetry.response.protocol**

My attempt:
- I could surface traces with Span description/Root span appStartTtiInvestigation - This transaction doesn't have network.client.execution spans
- I could also surface the list of transactions/root spans that have a span in the trace with span.op network.client.execution and value QUIC
- I can even check this value based on a per user.

What's missing: I haven't found a way to say: For this dataset, get me the users and for those users get me the appStartTtiInvestigation P90.

I don't think the Trace Explorer supports "find traces where span A has property X AND span B has property Y" in a single trace, hence I'm raising this here.

### Solution Brainstorm

_No response_

### Product Area

Explore

The issue names Explore and Trace Explorer but no files, tests, or entry points. Start by locating the Trace Explorer query implementation and its query tests; done means supporting the requested cross-span filtering and p90 calculation grouped by the relevant users.

Written by the indexing model from the issue text.