Lava Example - 61 | Rock Community

Lava Example - 75

Prompt

Here is a basic SQL query, using the {% sql %} command.

It's only getting the NickName and LastName - add Id to our results as well.

Initial Code

{% sql %}
    SELECT
        [NickName]
        , [LastName]
    FROM
        [Person]
    WHERE
        [LastName] = 'Decker'
{% endsql %}

<pre>{{ results | ToJSON }}</pre>

Solution Lava

{% sql %}
    SELECT
        [NickName]
        , [LastName]
        , [Id]
    FROM
        [Person]
    WHERE
        [LastName] = 'Decker'
{% endsql %}

<pre>{{ results | ToJSON }}</pre>