refactor: 서브쿼리 분리를 통해 쿼리를 개선한다 (#523) #365

	name: ✨ Celuveat Backend CI ✨

	on:
	push:
	branches:
	- develop-backend*
	- main
	paths:
	- 'backend/**'

	pull_request:
	branches:
	- develop-backend*
	- main
	paths:
	- 'backend/**'

	permissions:
	checks: write
	pull-requests: write

	jobs:
	backend-test:
	runs-on: ubuntu-latest
	env:
	working-directory: ./backend

	steps:
	- uses: actions/checkout@v3
	- name: ✨ JDK 17 설정
	uses: actions/setup-java@v3
	with:
	java-version: '17'
	distribution: 'temurin'

	- name: ✨ Gradle 의존성 캐싱
	uses: actions/cache@v3
	with:
	path: \|
	~/.gradle/caches
	~/.gradle/wrapper
	key: ${{ runner.os }}-gradle-${{ hashFiles('*/.gradle', '*/gradle-wrapper.properties') }}
	restore-keys: \|
	${{ runner.os }}-gradle-

	- name: ✨ Gradlew 권한 설정
	run: chmod +x ./gradlew
	working-directory: ${{ env.working-directory }}

	- name: ✨ 테스트 진행
	run: ./gradlew test
	working-directory: ${{ env.working-directory }}

	- name: ✨ 테스트 결과 Report
	uses: EnricoMi/publish-unit-test-result-action@v2
	if: ${{ always() }}
	with:
	files: '/build/test-results//*.xml'

	- name: ✨ 테스트 실패 Comment
	uses: mikepenz/action-junit-report@v3
	if: always()
	with:
	report_paths: '*/build/test-results/test/TEST-.xml'

Provide feedback