add 3 additional queries (for dashboard). Clean up the doublequotes that are no more nneeded.