Creating Virtual Layer with only desired fields

Question

My question is very similar to this one. The difference being I want multiple fields where they wanted only a single field.

I'm trying to create a virtual copy of my layer with only the following fields: "Acres", "Zoning", and "LinktoSOA".

I've tried these queries, but neither worked.

Select geometry, IN ["Acres", "Zoning", "LinktoSOA"]
from "WilmingtonParcels"

Select geometry, IN {"Acres", "Zoning", "LinktoSOA"}
from "WilmingtonParcels"

Select geometry, IN ("Acres", "Zoning", "LinktoSOA")
from "WilmingtonParcels"

Answer 1

I found a solution.

Select geometry, "Acres", "Zoning", "LinktoSOA"
from "WilmingtonParcels"

enter image description here