How to select data from database in wordpress

Here is the code

private static function get_blog_ids() {

 global $wpdb;

 // get an array of blog ids
 $sql = "SELECT blog_id FROM $wpdb->blogs
  WHERE archived = '0' AND spam = '0'
  AND deleted = '0'";

 return $wpdb->get_col( $sql );

}