TASK 1 - Ordering companies by sponsored and ranking

task-1-companies-order.php

$args   = [
    'post_type'         => 'company',
    'posts_per_page'    => 100,
    'meta_query'        => [
        'relation' => 'AND',
        [
            'key'   => 'sponsored',
            'value'  => [0,1]
            'compare' => 'IN'
        ],        
        [
            'key'   => 'ranking',
            'value' => [0,100],
            'compare' => 'BETWEEN',
            'type' => 'DECIMAL(4,1)'
        ]
    ],
    'orderby' => [
        'sponsored' => 'DESC',
        'ranking'   => 'DESC'
    ]
];