MySql to select progress data and return steps, completed, not_completed and progress

Return Progress Data

  /**
	 * Return the goal step progress values
	 * @param  int 		$id 	the goal id
	 * @return object 	contains goal step completion data
	 */
	public static function progress($id)
	{	
		$query = "SELECT 
					COUNT(completed) as total,
					COUNT(if(completed=1, 1, null)) as completed,
					COUNT(if(completed=0, 1, null)) as not_completed,
					(COUNT(if(completed=1, 1, null)) / COUNT(completed)  * 100) as progress
					FROM steps
					WHERE id_goal = '$id'";

		return DB::query($query);
	}