【Laravel】EloquentでWhereを使う方法について

$articles = Article::where('title', 'Laravel Basics')->get();

$articles = Article::where('title', 'Laravel Basics')
    ->where('status', 'published')
    ->get();

$articles = Article::where('status', 'draft')
    ->orWhere('views', '>', 100)
    ->get();

$articles = Article::whereBetween('views', [100, 500])->get();

$articles = Article::where('status', 'published')
    ->orWhereBetween('views', [100, 500])
    ->get();

$articles = Article::whereNotBetween('views', [100, 500])->get();

$articles = Article::whereIn('id', [1, 2, 3])->get();

$articles = Article::whereNotIn('id', [1, 2, 3])->get();

$articles = Article::whereNull('deleted_at')->get();

$articles = Article::whereNotNull('published_at')->get();

$articles = Article::whereColumn('id', '<=', 'views')->get();

$articles = Article::whereBetweenColumns('views', ['min_views', 'max_views'])->get();

$latestArticles = Article::where('id', function ($query) {
        $query->select('id')
              ->from('articles')
              ->orderBy('published_at', 'desc')
              ->limit(1);
    })
    ->get();

$articles = Article::whereExists(function ($query) {
    $query->select(DB::raw(1)) // ダミーの値を選択
          ->from('comments') // commentsテーブルを参照
          ->whereRaw('comments.article_id = articles.id'); // commentsとarticlesを関連付ける条件
})->get();